Category Archives: SQL Server

Introduction to Code First development with Entity Framework

The Database First approach is interesting when the database already exists. You use Visual Studio and the Entity Framework Designer to generate the C# and VB.NET classes which reflect the existing database model. You may then change relations using the … Continue reading

Posted in .Net, .Net 4.0, ASP.Net, ASP.Net MVC, SQL Server, WPF | Tagged , , , , , , | 4 Comments

SQL Server 2012 Release Candidate is now Available!

SQL Server 2012 RC is the first release which is feature complete and represents an exciting milestone for customers and partners looking to experience the full value of SQL Server 2012. Today, you have the chance to download, preview and … Continue reading

Posted in Miscellaneous, SQL Server | Tagged , | 1 Comment

How to enable remote connections to SQL Server 2008 using command line

Here is a small sql snippet, which will helps to enable remote connections using Command Line. It will enable remote connections to your SQL Server. Happy Coding

Posted in SQL Server | Tagged , , , , | Leave a comment

How to fix Error Code 29506, While installing SQL Management Studio Express on Windows 7 x64

Today I started installing SQL Server Management Studio express on my Windows 7 x64, and I started installing it, after few seconds, I got an error message like this This installer has encountered an unexpected error installing this package. This … Continue reading

Posted in SQL Server, Windows 7 | Tagged , , | Leave a comment

How to use Stored Procedures in Entity Framework

In the current project we are using Entity Framework for database operations. Entity Framework comes with Visual Studio SP1, which helps you to map tables / views / procedures as entities in C# / VB Code. You can find more … Continue reading

Posted in .Net, .Net 3.0 / 3.5, ASP.Net MVC, SQL Server, Windows Forms | Tagged , , , , | 3 Comments