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 Designer (or the XML mapping files) later to further optimize the model. The priority is [...]
Posts Categorized: SQL Server
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 deploy the full marquee capabilities being delivered in SQL Server 2012. RC is a production [...]
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
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 may indicate a problem with this package. The error code is 29506 My initial thought [...]
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 details about EF from here : http://msdn.microsoft.com/en-us/library/bb399572.aspx. In this post I am explaining how to [...]
Implementing Paging in SQL Server 2005 Stored Procedures
Normally for implementing Paging in Grid View, we enable the Paging property in GridView and will write code in the PageIndex Changed event. But the problem with this approach is it will fetch all the data from Database for Paging, will result wastage of network bandwidth and resources, also affect in the Page Performance. In [...]