how can convert this code into linq format

Gaurav Raj

//Here we will add a function for register notification (will add sql dependency)
public void RegisterNotification(DateTime currentTime)
{
string conStr = ConfigurationManager.ConnectionStrings["sqlConString"].ConnectionString;
string sqlCommand = @"SELECT [ContactID],[ContactName],[ContactNo] from [dbo].[Contacts] where [AddedOn] > @AddedOn";
//you can notice here I have added table name like this [dbo].[Contacts] with [dbo], its mendatory when you use Sql Dependency
using (SqlConnection con = new SqlConnection(conStr))
{
SqlCommand cmd = new SqlCommand(sqlCommand, con);
cmd.Parameters.AddWithValue("@AddedOn", currentTime);
if (con.State != System.Data.ConnectionState.Open)
{
con.Open();
}
cmd.Notification = null;
SqlDependency sqlDep = new SqlDependency(cmd);
sqlDep.OnChange += sqlDep_OnChange;
//we must have to execute the command here
using (SqlDataReader reader = cmd.ExecuteReader())
{
// nothing need to add here now
}
}

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Madan Shekar7y ago
First add add ADO .NET ENTITY MODEL your solution and select proper database. ofter this you can rewrite your sql query in linq

please refer this link
https://docs.microsoft.com/en-us/ef/ef6/modeling/designer/workflows/database-first

public void RegisterNotification(DateTime currentTime)
{
var result=(from tbl db.Contacts
where tbl.AddedOn > currentTime
select new
{
ContactID=tbl.ContactID,
ContactName=tbl.ContactName,
ContactNo=tbl.ContactNo
}).Tolist();
}
Laxmidhar Sahoo7y ago
var res = from s in db.context where s.AddedOn > @AddedOn select s
Gaurav Raj7y ago
hello
Kalyani Shevale
i know ,but i want to convert that paricular code into linq format...
i want to use SqlDependency in linq format
Kalyani Shevale7y ago
follow Below Link

https://www.c-sharpcorner.com/UploadFile/3d39b4/crud-operations-using-linq-to-sql-in-mvc/

https://www.codeproject.com/Articles/720471/A-Simple-MVC-Application-using-LINQ-to-SQL