Recently I worked on Linq to Sql for a web application, I was migrating a custom ORM framework to Linq to Sql. And most of the business logic of that application was in SQL Server by using Stored Procedures. This is the stored procedure And here is the Linq to Sql function which will return [...]
Posts Tagged: Stored Procedure
How to use Stored procedure in Entity Framework Code First
Another EF Code First post. Long back I post about how to use Stored Procedure in Entity Framework. (You can find it here). This post is about how to use stored procedure in Entity Framework Code First. Here is my stored procedure. And here is code snippet which will help to execute this Stored procedure. [...]
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 [...]
