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;
}
}
