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"; DbRawSqlQueryquery = context.Database.SqlQuery(sql,parameters); Listproducts = query.ToList(); foreach (SProduct product in products) { Console.WriteLine("{0}\t{1}\t售价:{2} 元", product.Id, product.Name, product.Price); } } Console.ReadKey();
[EF]使用参数
关注
打赏