private static void FunWIthEntitySQL()
{
using (AutoLotEntities context = new AutoLotEntities())
{
// 构建一个包含Entity SQL语法的字符串
string query = "SELECT VALUE car FROM AutoLotEntities.Cars " +
"AS car WHERE car.Color='black'";
// 现在基于该字符串构建一个ObjectQuery<T>
var blackCars = context.CreateQuery <Car>(query);
foreach (var item in blackCars)
{
Console.WriteLine(item);
}
}
}
private static void FunWithEntitySQL()
{
using (AutoLotEntities context = new AutoLotEntities())
{
// Build a string containing Entity SQL syntax.
string query = "SELECT VALUE car FROM AutoLotEntities.Cars AS car WHERE car.Color='black'";
// Now build a ObjectQuery<T> based on the string.
var blackCars = context.CreateQuery <Car>(query);
foreach (var item in blackCars)
{
Console.WriteLine(item);
}
}
}
private static void FunWithEntitySQL()
{
using (AutoLotEntities context = new AutoLotEntities())
{
// Build a string containing Entity SQL syntax.
string query = "SELECT VALUE car FROM AutoLotEntities.Cars AS car WHERE car.Color='black'";
// Now build a ObjectQuery<T> based on the string.
var blackCars = context.CreateQuery<Car>(query);
foreach (var item in blackCars)
{
Console.WriteLine(item);
}
}
}