Category LINQ

Delete Rows from DataTable Using Linq in C#Read More

Update Field Value in DataTable using Linq in C#Read More

Entity Model Name  :

TestLinqDataContext db = new TestLinqDataContext();
var obj=from p in db. TagMasters
where p.TagCode == TextBox2.Text
select p;

https://plus.google.com/103205117009535639356Read More

Entity Model Name  :

TestLinqDataContext db = new TestLinqDataContext();
var detail = from p in db.TagMasters
orderby p.ExpirationDate descending

https://plus.google.com/103205117009535639356Read More

Entity Model Name  :

TestLinqDataContext db = new TestLinqDataContext();
var result = (from p in db.TagMasters
join
t in db.TagRegistrations on p.ID equals t.TagId
group t by new { p.TagCode, t.DateCreated } into g
select new { g.Key.TagCode,g.Key.DateCreated}).Distinct();

https://plus.google.com/103205117009535639356Read More

Entity Model Name  :

TestLinqDataContext db = new TestLinqDataContext();
var topDate = db.TagMasters.Take(3);

https://plus.google.com/103205117009535639356Read More

Entity Model Name  :
TestLinqDataContext db = new TestLinqDataContext();

 

var innerQuery = (from fb in db. TagMasters orderby fb.ExpirationDate descending select fb.ExpirationDate).Take(3).Distinct();
var result = (from f in db.TagMasters
where innerQuery.Contains(f.ExpirationDate)
// Notice here, grouping by a constant value
group f by 1 into g
select g.Max(t => t.ExpirationDate) );

https://plus.google.com/103205117009535639356Read More

Entity Model Name  :
TestLinqDataContext db = new TestLinqDataContext();

var obj = from p in db.TagMasters
where SqlMethods.Like(p.TagCode, “%” + TextBox2.Text + “%”)
select new {
p.TagCode,p.Status,p.ExpirationDate
};

https://plus.google.com/103205117009535639356Read More

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 Read More

Language Integrated Query (LINQ) provides .NET developers some new and exciting features to query and manipulate data in a consistent and uniform way. It enables them to work with different type of data sources such as Arrays, collection of objects, XML documents, a relational databases, Active Directory or even Microsoft Excel sheets by writing or embedding queries in C# or Visual Basic language. Microsoft has introduced many new keywords and features in both C# and Visual Basic languages to integrate LINQ technology. Microsoft has also added new namespaces in .NET Framework Library that contains new interfaces and hundreds of extension methods also called LINQ query operators. These methods perform different operations on different type of data sources in LINQ. LINQ stands for Language-Integrated Query. Basically LINQ address the current database development model in the context of Object Oriented Programming Model. If some one wants to develop database application on .Net platform the very simple approach he uses ADO.Net. ADO.Net is serving as middle ware in application and provides complete object oriented wrapper around the database SQL.So developer must have good knowledge of object oriented concept as well as SQL to develop an application. But incase of Linq SQL statements are become part of the C# and VB.Net code so there are less chance of mistake.Read More