public void Search(string name) { string querystring = "Update Employees set SearchCount = SearchCount+1 where Name LIKE '%" + name + "%'"; using (var ctx = new EmployeeDB()) { var student = ctx.Employees .FromSqlRaw(querystring); } // FormattableString querystring1 = $"Select * from Employees where Name LIKE '%{name}%'"; // using (var ctx = new EmployeeDB()) // { // var student = ctx.Employees // .FromSqlInterpolated(querystring1) // .FirstOrDefault(); // student = ctx.Employees // .FromSqlInterpolated($"Select * from Employees where Name LIKE '%{name}%'") // .FirstOrDefault(); // } querystring = "Update Employees set SearchCount = SearchCount+1 where Name LIKE '%" + name + "%'"; using (var ctx = new EmployeeDB()) { int noOfRowUpdated = ctx.Database.ExecuteSqlCommand(querystring); noOfRowUpdated = ctx.Database.ExecuteSqlCommand(querystring, new SqlParameter("@name", name)); noOfRowUpdated = ctx.Database.ExecuteSqlCommandAsync(querystring).Result; noOfRowUpdated = ctx.Database.ExecuteSqlCommandAsync(querystring, new SqlParameter("@name", name)).Result; noOfRowUpdated = ctx.Database.ExecuteSqlRaw(querystring); noOfRowUpdated = ctx.Database.ExecuteSqlRaw(querystring, new SqlParameter("@name", name)); noOfRowUpdated = ctx.Database.ExecuteSqlRawAsync(querystring).Result; noOfRowUpdated = ctx.Database.ExecuteSqlRawAsync(querystring, new SqlParameter("@name", name)).Result; } }
public void Search(string name) { string querystring = "Select * from Employees where Name LIKE '%@name%'"; using (var ctx = new EmployeeDB()) { var student = ctx.Employees .SqlQuery(querystring, new SqlParameter("@name", name)) .FirstOrDefault(); } querystring = "Select * from Employees where Name LIKE '%" + name + "%'"; using (var ctx = new EmployeeDB()) { var student = ctx.Employees .SqlQuery(querystring) .FirstOrDefault(); } using (var ctx = new EmployeeDB()) { string studentName = ctx.Database.SqlQuery <string>(querystring) .FirstOrDefault(); } querystring = "Update Employees set SearchCount = SearchCount+1 where Name LIKE '%" + name + "%'"; using (var ctx = new EmployeeDB()) { int noOfRowUpdated = ctx.Database.ExecuteSqlCommand(querystring); noOfRowUpdated = ctx.Database.ExecuteSqlCommandAsync(querystring).Result; } //querystring = "Update Employees set SearchCount = SearchCount+1 where Name LIKE '%@name%'"; using (var ctx = new EmployeeDB()) { int noOfRowUpdated = ctx.Database.ExecuteSqlCommand(querystring, new SqlParameter("@name", name)); noOfRowUpdated = ctx.Database.ExecuteSqlCommandAsync(TransactionalBehavior.DoNotEnsureTransaction, querystring, new SqlParameter("@name", name)).Result; } }