LINQ Extension Method in C#
Posted inLINQ

LINQ Extension Method in C#

Filtering: Where, OfTypeSorting: OrderBy, OrderByDescending, ThenBy, ThenByDescending, ReverseGrouping: GroupByJoin: JoinProject: Select, SelectManyAggregation: Average, Count, Max, Min, SumQuantifiers: All, Any, ContainsElements: ElementAt, ElementAtOrDefault, First,…
Calling an stored procedure using ADO.NET Entity Model (Entity Framework LINQ to SQL)
Posted inASP.NET ENTITY FRAMEWORK LINQ

Calling an stored procedure using ADO.NET Entity Model (Entity Framework LINQ to SQL)

In this article I would like to share something regarding Entity Framework, how we can implement operations using Stored Procedures in Entity Framework. SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Users]( [Uid] [int] IDENTITY(1,1) NOT NULL, [Fname] [nvarchar](50) NULL, [Lname] [nvarchar](50) NULL, [Email] [nvarchar](50) NULL, [Gender] [nvarchar](50) NULL, [Address] [nvarchar](50) NULL, CONSTRAINT [PK_Users] PRIMARY KEY CLUSTERED ( [Uid] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO SET ANSI_NULLS ON GO