using (adventureworksEntities database = new adventureworksEntities())
{
// Retrieve the details of the selected product
Product product = (from p in database.Products
where string.Compare(p.ProductNumber, productNumber) == 0
select p).First();
// Create and populate a new shopping cart item
ShoppingCartItem newItem = new ShoppingCartItem
{
ProductNumber = product.ProductNumber,
ProductName = product.Name,
Cost = product.ListPrice,
Volume = 1
};
// Add the new item to the shopping cart
shoppingCart.Add(newItem);
// Indicate success
return true;
}
{
// Retrieve the details of the selected product
Product product = (from p in database.Products
where string.Compare(p.ProductNumber, productNumber) == 0
select p).First();
// Create and populate a new shopping cart item
ShoppingCartItem newItem = new ShoppingCartItem
{
ProductNumber = product.ProductNumber,
ProductName = product.Name,
Cost = product.ListPrice,
Volume = 1
};
// Add the new item to the shopping cart
shoppingCart.Add(newItem);
// Indicate success
return true;
}
在 using (adventureworksEntities database = new adventureworksEntities())这一句的时候没有出错,但是在
Product product = (from p in database.Products
where string.Compare(p.ProductNumber, productNumber) == 0
select p).First();
却出错了基础程序在Open上失败了的错误提示。
错误原因:
自己没有把Sqlexpress打开导致的。
解决方案:
把SqlExpress服务打开 。