Visual Studio 11 database projects and Unit Testing SQL Server database

Please find the slides and demos for the session I presented at Microsoft User Group Hyderabad(MUGH). The agenda of the session was Overview about Database Projects Database development with SQL Server Data Tools(Code-named Juneau) DEMO – Database development using SQL Server Data Tools and Visual Studio 11 Basics of Database Unit Testing DEMO – Unit…

2

Utility to generate Word documents from templates using Visual Studio 2010 and Open Xml 2.0 SDK – Part 4

[Update: The source code has been updated to Visual Studio 2017 and DocumentFormat.OpenXml 2.8.1. You can download the code from GitHub.] This is the fourth part of this series. The code is available for download at http://worddocgenerator.codeplex.com/. In Part 1 I discussed about Document generation using Content Controls and Open XML 2.0 SDK Creating Word templates Implementation…

3

How to use Pex and Moles to generate unit tests for a project having external dependency(WCF Proxy) using Visual Studio 2010 SP1

Source Code: In this post I’ll discuss about writing unit tests using Pex and Moles. Pex and Moles are Visual Studio 2010 Power Tools that help Unit Testing .NET applications. Pex automatically generates test suites with high code coverage. Right from the Visual Studio code editor, Pex finds interesting input-output values of your methods, which…

1

How to unit test SQL Server 2008 database using Visual Studio 2010

In this article I’ll discuss about unit testing SQL Server 2008 Database project using Visual Studio 2010. As Unit tests test the part of the program integration testing becomes easier, moreover unit tests help enhancing, maintaining or extending a solution provided they are well written. This is first part of this series “How to unit…

4