Entity SQL 示例 不能正确执行
using (AdventureWorksEntities AWEntities = new AdventureWorksEntities())
{
ObjectQuery<Product> products = AWEntities.Product;
IQueryable<Product> productsQuery = from product in products
select product;
Console.WriteLine("Product Names:");
foreach (var prod in productsQuery)
{
Console.WriteLine(prod.Name);
}
}
Console.WriteLine("Product Names:"); 可以正常执行,
执行 foreach 就直接异常返回, 且异常无法捕获,
在调试输出窗口显示 引发的异常:“System.Data.SqlClient.SqlException”(位于 System.Data.dll 中)
该代码示例地址 https://msdn.microsoft.com/zh-cn/library/bb738694(v=vs.90).aspx