using (var context = new KTStoreContext())
{
// object[] parameters = { 8, "%移动%" };
SqlParameter P0 = new SqlParameter("P0", 8);
SqlParameter P1 = new SqlParameter("P1", "%移动%");
SqlParameter[] parameters = { P1, P0 };
String sql =
"SELECT Id,Name,Price FROM Product WHERE Id > @P0 AND Name LIKE @P1";
DbRawSqlQuery<SProduct> query =
context.Database.SqlQuery<SProduct>(sql,parameters);
List<SProduct> products = query.ToList();
foreach (SProduct product in products)
{
Console.WriteLine("{0}\t{1}\t售价:{2} 元",
product.Id, product.Name, product.Price);
}
}
Console.ReadKey();
[EF]使用参数
最新推荐文章于 2024-04-22 16:21:04 发布