Tag | BlogFeedList.aspx Posts

Entity Framework is an object-relational mapping framework that can be used to work with data as objects. While you can run the ADO.NET Entity Data Model wizard in Visual Studio to handle generating the Entity Model for yourself, this can put you at a disadvantage if there are changes in your data source or if you want more control over how the entities operate. In this article we will demonstrate a Code First approach to accessing your QuickBooks Data using the RSSBus ADO.NET Provider. Even though ...
Using SQL Server as a backup for critical business data provides an essential safety net against loss. In addition, backing up data to SQL Server enables business users to more easily connect that data with features like reporting, full-text search, analytics, and more. This example demonstrates how to use the QuickBooks ADO.NET Data Provider inside of a SQL Server SSIS workflow to transfer data directly from QuickBooks and/or QuickBooks Online into a Microsoft SQL Server database. The exact same ...
Using SQL Server as a backup for critical business data provides an essential safety net against loss. In addition, backing up data to SQL Server enables business users to more easily connect that data with features like reporting, full-text search, analytics, and more. This example demonstrates how to use the SalesForce ADO.NET Data Provider inside of a SQL Server SSIS workflow to transfer data directly from SalesForce account into a Microsoft SQL Server database. Step 1: Open Visual Studio and ...
This article walks through the process of using the SharePoint Data Provider and authenticating with SharePoint Online / Office 365. This tutorial covers how to perform this programmatically and with the Visual Studio Server Explorer. In addition to accessing lists from local installations of SharePoint server, the SharePoint Data Provider also supports accessing lists from SharePoint Online. SharePoint Online and Office 365 authentication requires a cookie based authentication. To connect to SharePoint ...
In this demo, we will demonstrate how to use LINQ to access tables in QuickBooks through the QuickBooks ADO.NET Data Provider. To do this we will LINQ to Entity Framework, which is used to generate the connection and can be used with any RSSBus ADO.NET Data Providers to access data via LINQ. Step 1: Open Visual Studio and create a new project. Step 2: Right click on the project and choose to add a new item. Select to add an ADO.NET Entity Data Model. Step 3: Choose to generate from database and click ...
The RSSBus Data Providers for ADO.NET include out-of-the-box support for Microsoft Visual Studio LightSwitch. In this demo, we will show you how to create a LightSwitch application that connects with QuickBooks and displays QuickBooks account data through the QuickBooks ADO.NET Data Provider. This exact same procedure outlined below can be used with any RSSBus ADO.NET Data Providers to integrate data with LightSwitch applications. Before We Begin QuickBooks provides no connectivity to its data over ...
Are you looking for a quick and easy way to access your Google Docs from PowerShell? The Google Data Provider provides an easy-to-use ADO.NET interface that you can take advantage of with your PowerShell Scripts. Simply use the included SQL like .NET objects (GoogleConnection, GoogleCommand, GoogleDataAdapter, etc) in your PowerShell scripts to connect to your Google Apps accounts and synchronize, automate, download, and more! Using the Google Data Provider in PowerShell to List Google Docs: # Load ...
Charts can be essential when it comes to displaying critical information or making decisions based on the most recent information. Using the SalesForce ADO.NET Provider, you can easily chart your SalesForce Data in Visual Studio. This article demonstrates how easy it is to get your SalesForce data and databind it to a chart. For this example, we will use the Microsoft Charting controls available in .NET 3.5. The exact same procedure outlined below can be used with any RSSBus ADO.NET Data Providers ...
Agile taught us to release early and release often, Agile also taught us to get the end user involved more frequently and directly. Goes without saying that release notes are an important part of any release. But what you don’t want to be doing is manually putting together the release notes with each frequent release you do. TFS lets you manage the application lifecycle with great ease & minimal administrative overhead, if your team is already checking in the code against work items and if you ...
Welcome to the hidden treasure of “MTM.config.exe” Navigate to “C:\Program Files (x86)\Microsoft Visual Studio 11.0\Common7\IDE” and open the 1. Can I change the number of Action Recording steps selected when a Bug is created? When you are exploratory testing using Microsoft Test Manager or performing a feedback session using Feedback Manager and decide to raise a bug or create a test case, the last 4*10 Action recordings are selected by default. You can change the number of action recordings selected ...
In this blog post I’ll show you how to use the TFS 2011 API to get the Exploratory Testing & Feedback Manager session information programmatically. Introduction TFS 2011 includes Exploratory Testing and Feedback Manager, the first empowers the testers to explore the application and second empowers the stake holders to explore the application. This rhymes a bit… that’s because… under the hood both use the same infrastructure to drive and store the session information. If you try to run both at ...
In this blog post I’ll be walking you through the process of customizing the TFS 2011 Scrum 2.0 Process Template to add a new work item type, introducing new work item queries, modifying existing queries, adding new reports, etc. To give you a bit of context, at the 2011 ALM Summit Anu Bharadwaj presented a talk on Exploratory Testing highlighting how the Team @ Microsoft took advantage of MTM 2011 to test various VS ALM products in the “fun” way by organizing “Testing Tours.” To dive deep in to ...
Is this blog post worth your time? It’s not challenging setting up the Load Test Rig in the Cloud, it’s more challenging to convince enterprises to embrace the cloud. Not all enterprises will accept their business critical applications being profiled from a VM hosted outside their network. Though through Windows Azure Connect you can join the Cloud hosted Role to the on premise domain effectively forcing the domain policies on the external VM but how many enterprises will authorize you to do this? ...
Welcome to Part 2, In Part 1 we discussed the advantages of creating a Test Rig in the cloud, the Azure edge and the Test Rig Topology we want to get to. In Part 2, Let’s start by understanding the components of Azure we’ll be making use of followed by manually putting them together to create the test rig, so… let’s get down dirty start setting up the Test Rig. What Components of Azure will I be using for building the Test Rig in the Cloud? To run the Test Agents we’ll make use of Windows Azure Compute ...
Azure is fascinating, but even more fascinating is the marriage of Azure and TFS! Introduction Recently a client I worked for had 2 major businesses critical applications being delivered, with very little time budgeted for Performance testing, we immediately hit a bottleneck when the performance testing phase started, and the in house infrastructure team could not support the hardware requirements in the short notice. It was suggested that the performance testing be performed on one of the QA environments ...
Download Demo Solution - here In this blog post I’ll show you how to use the TFS API to get the name of the Process Template that is currently applied to the Team Project. You can also download the demo solution attached, I’ve tested this solution against TFS 2010 and TFS 2011. 1. Connecting to TFS Programmatically I have a blog post that shows you from where to download the VS 2010 SP1 SDK and how to connect to TFS programmatically. private TfsTeamProjectCollection _tfs; private string _selectedTeamProject; ...
Ever found your self in this helpless situation where you think you have tried every possible suggestion on the internet to bring the build server back but it just won’t work. Well some times before hunting around for a solution it is important to understand what the problem is, if the error messages in the build logs don’t seem to help you can always enable tracing on the build server to get more information on what could possibly be the root cause of failure. In this blog post today I’ll be showing ...
Welcome back once again, in Part 1 of Load and Web Performance Testing using Visual Studio 2010 I talked about why Performance Testing the application is important, the test tools available in Visual Studio Ultimate 2010 and various test rig topologies, in Part 2 of Load and Web Performance Testing using Visual Studio 2010 I discussed the details of web performance & load tests as well as why it’s important to follow a goal based pattern while performance testing your application. In part 3 I’ll ...
Welcome back, in part 1 of Load and Web Performance Testing using Visual Studio 2010 I talked about why Performance Testing the application is important, the test tools available in Visual Studio Ultimate 2010 and various test rig topologies. In this blog post I’ll get into the details of web performance & load tests as well as why it’s important to follow a goal based pattern while performance testing your application. Tools => Options => Test Tools Have you visited the treasures of Visual ...
Performance testing is almost always conducted to address one or more risks related to expense, opportunity costs, continuity, and/or corporate reputation. But not everyone thinks their application requires investment in performance testing. We presented few of our clients who were heavily focussed on functional requirements but did not care too much about the Non-functional requirements with a short questionnaire, User’s will be happy if the website loaded in <= ___ seconds. How many extra seconds ...
????? ???????? ?? 17% ???? ??? ???? ??, ???? ?? ??? ??? ??? ???? 500,000 ?????????? ?? ??????? ???? ??. ???? ?? ????????? ???? ????? ??, 2007 ?? ?????? ??????????? ?? ?????? ?????? ?? ?? ????? 336 ?????? ????? ?????? ???? ???? ??. ??? ?? ?? ???? ????? ???? ???? ??, ?????? ???? ??? ???????? ????? 2011 ?? ????? ?? ??? ???? ?????? ??????????? ?? ??? ??. ?????? 6 ???????????? ?? 4 ???????? ?? ?? ??? ?? ?????? ??? ??. ??????? ???? => ??? ???????? ????? 2011 ??????????? ????? ????? ???? ??? ??????? ...
There is no one best branching strategy, the branching strategy that best fits the requirements of your enterprise is the best strategy for you. The ALM rangers have comprehensive guidelines to help you decide what might work best with your enterprise. A couple of parameters you need to consider while thinking about the branching strategy are, What is the length of the Iteration your team will be delivering in. Agile – Weeks, Waterfall – Months. Would you have multiple versions of the applications ...
Welcome back once again, in part 1 of what is new in VS TFS 2011 I talked about the offering from a developers perspective, in part 2 of what is new in VS TFS 2011 I talked about the offering from a Testers and Business Analysts perspective. In this blog post I’ll be discussing the new features available for Project Managers and TFS Administrators. One thing that project Managers loved about TFS 2010 was the linking of work items, see work structured by category i.e. testers having their own tasks, ...
Welcome back, in part 1 of what is new in VS TFS 2011 I talked about the offering from a developers perspective. In this blog post I’ll be discussing the new features available for Business Analysts and Testers. While working on various ALM implementations the biggest challenge has been to strike the right balance between tools and processes, it is important to re-enforce that there is no substitute for communication. The delivery of a project on time and on budget are not the sole indicators of ...
Microsoft officially released the preview of Vnext i.e. VS 2011, TFS 2011 and TFS Azure (also known as TFS Service) at the Build conference on 13th September 2011 @ California. It wasn’t too long ago I remember helping customers set up ALM processes using TFS 2010, so what are the compelling reasons these customers who have heavily invested in TFS 2010 should consider moving on to TFS 2011. In this blog post I’ll try and answer what exactly is new in TFS 2011, how TFS 2011 is different from TFS 2010. ...
Download a working demo (below): No showing off, this has been developed in VS11 using MTM11 and version controlled in TFS Azure Working Demo = Download-Testing Scorecard In this blog post I’ll be showing you how to use the TFS API to build a testing scorecard. In this testing score card, I’ll be going through each of the test plans programmatically looping through test suits (yes, the test suits can be nested) looking for test cases and querying their status and further going in at the test step ...
Download a working Demo: Working Demo Download In this blog post I'll show you how to use the TFS API to get the security groups, members, permissions and security settings of users in Team Projects in TFS. Problem I would like to see the version control permissions and security settings for each user in a Group for each Team Project. Can I see all of this in one place in a report? Solution Is the report below similar to what you are looking for? Let’s build one using the TFS SDK… if you enjoy the ...
Our friends at Microsoft have done a wonderful job releasing TFS 2011 preview, there has been great amount of preview documentation and video samples released to help understand the new features. In this blog post I intend to dive deep and compare the database changes done between the two versions of the product. If you are interested to read more about the actual features of TFS 2011, please refer to bharrys blog posts, this, this and this. I’ll be using the following pattern, About the feature ...
Microsoft has officially launched the TFS Azure service preview also known as TFS in the cloud. I am sure not all of us would be upgrading our base machines by installing Visual Studio 2011 which is still in preview to work with TFS Azure. The good news is that it is possible to work with TFS Azure using Visual Studio 2010. In this blog post, I’ll be showing you how to set up a developer machine with Visual Studio 2010 and connecting to TFS Azure. => Set up a new machine with Visual Studio 2010 ...
To connect and authenticate with the Team Foundation Service Preview you need to install the hotfix KB2581206. While setting up a new machine to work with TFS Azure (#TfsService) i encountered a problem after installing service patch KB2581206. Reason: if you fail to install service pack 1 before installing the hotfix you might see strange behaviour with Visual Studio. Thanks to Trevor from Microsoft for confirmation. => How can I tell if i have Visual Studio Service Pack 1 installed? If you have ...
I have been part of the Azure TFS Technical Access Preview (TAP) since March 2011. TFS Azure has been previewed and officially announced as TFS Service in the 2011 Build Conference, California. The Non-Disclosure Agreement has been lifted from the participants of the TAP program. The below excerpt from bharrys blog encourages early adopters to provide feedback. "We’ve been running the service for months now and it’s been working reliably. I suspect now that they can talk about it, you’ll be able ...
Download Demo - LINQpad Query In this blog post I’ll be showing you how to query TFS using LINQpad. 1. Download LINQpad Those who are familiar with LINQpad know its benefits and ease of use, i would urge others to try it. You can download LINQpad and read more about it from here => http://www.linqpad.net/ 2. Download TFS SDK I have a blog post on where and how to download the TFS SDK from => here 3. Querying TFS using LINQpad Open LINQpad Select Query Properties by selecting Query from menu ...
The Team Explorer is a wonderful view of the position of your version control in the team foundation server. However, there is no one window of such truth available for the workspace. I am a very active member of the msdn community and have come across questions on, How do I see a list of all files that are not mapped to TFS but are in my workspace? (Yes, you can use the TFS power tools tfpt.exe /scorch or /treeclean to achieve this) I would like to see all pending changes in just one folder and ...
Download from here If you track your project tasks against work items, you would know the importance of Work Item History. This is one way for you to reflect on who did what and when, some organizations use it for auditing purposes as well. Using the WorkItemStore service it is possible to get the work item revisions, now depending on how creative you are, you can plot the data and visualize the changes as you like. In this blog post I'll be showing you, How to get the work item history programmatically ...
Lately i have seen the below remarks coming through in the communities, Get Latest does not work in TFS I always have to use Get Specific version to get the server changes on my local Why get latest misses updating some files while get specific works I’ll be using the TFS API to show you how the “Get Latest” is suppose to work and show you how you can avoid getting in a situation where you might have to use “Get Specific” to get the latest version of your workspace. I would assume that you know the ...
I will be covering three things in this blog post Get the history i.e. all change sets of an item programmatically using the TFS API. Download the change sets programmatically using the TFS API Use WinMerge to compare those change sets programmatically 1. How do i get the history of a file using TFS API? The VersionControlServer Class exposes the QueryHistory method that gets you all changesets that have impacted a file or folder you are querying for. public IEnumerable QueryHistory( string path, ...
Technorati Tags: Team Foundation Server 2010,TFS SDK,TFS API,TFS Merge Programmatically,TFS Work Items Programmatically,TFS Administration Console,ALM Download a working Demo: Smart Merge using TFS API The information available in the Merge window in Team Foundation Server 2010 is very important in the decision making during the merging process. However, at present the merge window shows very limited information, more than often you are interested to know the work item, files modified, code reviewer ...
After you download and install the January 2011 Windows Phone update, you will notice one annoying thing. The default deployment target for Windows Phone Projects in Visual Studio changes to Windows Phone 7 Device. Before the update, it defaulted to the Emulator. I found this extremely annoying as I’m more than likely going to test with the emulator before putting it on my actual device. Now to make things fair, Microsoft told you they were going to switch the default and even provided a solution, ...
In case you haven’t heard the latest WP7 Developers Tool update was released yesterday and contains a few goodies. First you need to go and grab the bits here. You can install them in any order, but I installed the WindowsPhoneDeveloperResour... first. Then the VS10-KB2486994-x86.exe. They install silently. In other words, you would need to check Programs and Features and look in Installed Updates to see if they installed successfully. Like the screenshot below: Once you get them ...
Silverlight is a great product right off the shelf. I use it, love it and spend a lot of time helping the community understand it. This however, doesn’t mean that I don’t think that it can get better. If I were invited to a Microsoft Focus Group about Silverlight here is 10 things I would say: We need more navigation templates. I’ve found (4) templates that Microsoft has released (Cosmo, Windows 7, Accent and JetPack). This number needs to be around 16. In order to get more people developing for ...
I hate re-writing code. I also hate it when I find a great code snippet on the web and forget to bookmark it or it gets lost in my endless sea of bookmarks. So what do you do to get around this? This is the question that I was asking myself at the end of 2010. How can I get my Silverlight code organized? My requirements for a snippet manager were: Needs to be FREE. An easy way to view XAML/C# code behind together in one “view”. I wanted the ability to store the code snippets in cloud in case my HDD ...
Silverlight/Expression 4 Books! I recently stumbled upon a post asking, “What is the best book on Silverlight 4?” In the age of the internet, it can be hard for anyone searching for a good book to actually find it. I have read a few Silverlight 4/Expression books in 2010 and decided to post the “best of” collection. Instead of reading multiple books, you can cut your list down to whatever category that you fit in. With Silverlight 5 coming soon, now is the time to get up to speed with what Silverlight ...
Part 1 | Part 2 | Part 3 | Part 4 I wanted to create a series of blog post that gets right to the point and is aimed specifically at Silverlight Developers. The most important things I want this series to answer is : What is it? Why do I care? How do I do it? I hope that you enjoy this series. Let’s get started: Tip/Trick #16) What is it? Find out version information about Silverlight and which WebKit it is using by going to http://issilverlightinstall... Why do I care? I’ve had ...
Part 1 | Part 2 | Part 3 | Part 4 I wanted to create a series of blog post that gets right to the point and is aimed specifically at Silverlight Developers. The most important things I want this series to answer is : What is it? Why do I care? How do I do it? I hope that you enjoy this series. Let’s get started: Tip/Trick #11) What is it? Underline Text in a TextBlock. Why do I care? I’ve seen people do some crazy things to get underlined text in a Silverlight Application. In case you didn’t know ...
Silverlight 5 is coming next year (2011) and this blog post will tell you what you need to know before the beta ships. First, let me address people saying that it is dead after PDC 2010. I believe that it’s best to see what the market is doing, not the vendor. Below is a list of companies that are developing Silverlight 4 applications shown during the Silverlight Firestarter. Some of the companies have shipped and some haven’t. It’s just great to see the actual company names that are working on Silverlight ...
Part 1 | Part 2 | Part 3 | Part 4 I wanted to create a series of blog post that gets right to the point and is aimed specifically at Silverlight Developers. The most important things I want this series to answer is : What is it? Why do I care? How do I do it? I hope that you enjoy this series. Let’s get started: Tip/Trick #6) What is it? Create a Notification Window in a Silverlight Out Of Browser Application. Why do I care? Its a great way to alert users of something that needs their attention. ...
Part 1 | Part 2 | Part 3 | Part 4 I wanted to create a series of blog post that gets right to the point and is aimed specifically at Silverlight Developers. The most important things I want this series to answer is : What is it? Why do I care? How do I do it? I hope that you enjoy this series. Let’s get started: Tip/Trick #1) What is it? You can easily enable a visual Framerate counter inside your Silverlight Application. The end result looks like the image below: Why do I care? This should be used ...
I was lucky enough to attend Visual Studio Live! in Orlando on November 14th-17th. There were so many great speakers and the networking was great. I met a lot of really cool people and we talked about everything .NET (from WP7, Silverlight, C#, ASP.NET WebForms, AJAX, MVC 3.. and so forth). I took a lot of notes during all the sessions and wanted to provide it to those that could not come out. If you follow me on Twitter then you have seen most of these. Most of the authors put slides/source code ...
This is the last post in a series of articles detailing the process of building/deploying a WP7 application. I’ve walked you through setting up the tools, to playing with the hardware to deploying your application to the actual hardware. Now I’m going to show you how to submit an app to the market. I’ve provided a link to all the articles mentioned below. From start to finish with the final version of Visual Studio Tools for Windows Phone 7 Hands-on : Windows Phone 7 Review Deploying your Windows ...
If you build Silverlight Applications, chances are you have seen this screen before. I’m talking about the default “To view this content, please install…” Screen shown below. The Default Installation Screen. This is the screen that your users see when they first visit your site without Silverlight installed. It’s just plain ugly and most users do not know what it means. Take this example below by Netflix, they have alerted the user with a friendly: “You’re almost ready to watch…” Install Now. This ...