Category >
LINQ
|| Published on :
Sunday, April 26, 2015 || Views:
8894
||
SqlClient.SqlFunctions.DateDiff in LINQ LINQ Examples SqlClient.SqlFunctions.DateDiff
In some situation, we have to filter or delete or get records whose creation times comes under particular time like 1 hour or two hour. In below example I will going to demostrate how to use SqlClient.SqlFunctions.DateDiff in Entity Framework to delete some records which are older than 2 hours.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 | public DB DeleteOldRecords(DEMOEntities objEntities)
{
Result = DB.Unknown;
try
{
using (objEntities)
{
(from p in objEntities.tblDEMO.Where(x => System.Data.Objects.SqlClient.SqlFunctions.DateDiff("hour", x.Timestamp, DateTime.Now) >= 2) select p).ToList().ForEach(objEntities.DeleteObject);
objEntities.SaveChanges();
}
Report(DB.OK);
}
catch (Exception ex)
{
this.Report(DB.Error, ex);
}
return Result;
}
|
So, In this tutorial, you have learn, How to make use SqlClient.SqlFunctions.DateDiff in LINQ with example.
Stay Tunned for more articles like this.