public static void AddData(KTStoreModel context)
{
if (context.Product.Count() <= 5)
{
var data1 = new Product()
{
Name = "ASUS",
Price = 39000M,
Quantity = 1
};
var data2 = new Product()
{
Name = "APPLE MAC",
Price = 60000M,
Quantity = 1
};
var data3 = new Product()
{
Name = "LENOVO",
Price = 32000M,
Quantity = 1
};
var data4 = new Product()
{
Name = "HP",
Price = 39000M,
Quantity = 1
};
context.Product.AddRange(new List <Product>()
{
data1, data2, data3, data4
});
context.SaveChanges();
}
}
public static void LocalQuery(KTStoreModel context)
{
//part 1
//Console.WriteLine($"Before query DB Amount:{context.Product.Count()} ");
//Console.WriteLine($"Before query Local Amount:{context.Product.Local.Count()} ");
//Console.WriteLine();
//Console.WriteLine("After query...");
//foreach (var VARIABLE in context.Product)
//{
// //do something...
//}
//Console.WriteLine($"After query Local Amount:{context.Product.Local.Count()} ");
//Console.WriteLine($"After query DB Amount:{context.Product.Count()} ");
//Console.WriteLine();
//var product = new Product() //跑錯棚的商品
//{
// Name = "統一科學麵",
// Price = 20,
// Quantity = 1
//};
//context.Product.Add(product); //做假資料
//Console.WriteLine($"After add test data...");
//Console.WriteLine($"Before DB Amount:{context.Product.Count()} ");
//Console.WriteLine($"Before Local Amount:{context.Product.Local.Count()} ");
//part 2
Console.WriteLine($"Before query DB Amount:{context.Product.Count()} ");
Console.WriteLine($"Before query Local Amount:{context.Product.Local.Count()} ");
context.Product.Load(); //執行此行資料就已經載入Local
Console.WriteLine($"After query DB Amount:{context.Product.Count()} ");
Console.WriteLine($"After query Local Amount:{context.Product.Local.Count()} ");
}
static void Main(string[] args)
{
using (var context = new KTStoreModel())
{
//context.Database.Log = Console.Write;
//ObjectContextDemo(context);
//DbContextDemo(context);
//DbSetFindDemo(context);
//DbSetFindDemo(context, 1,"ASUS");
//DbSetFindDemo(context, 5, "MSI");
//DbSetUpdateDemo(context);
//DbSetRemoveDemo(context);
LocalQuery(context);
}
Console.Read();
}
public static void ShowDBSetting(KTStoreModel context)
{
Console.WriteLine($@"
連接字串:{context.Database.Connection}
DB Name:{context.Database.Connection.Database}
ServerName Name:{context.Database.Connection.DataSource}
ConnectionState:{context.Database.Connection.State}
");
}
public static void DbSetFindDemo(KTStoreModel context, int productIndex, string name = "")
{
Product product;
product = context.Product.Find(productIndex, name);
if (product != null)
{
Console.WriteLine(product.Name);
}
}
public static void DbSqlQueryDemo(KTStoreModel context)
{
var sql = "Select * From Products Where price<=@price";
var result = context.Product.SqlQuery(sql, new SqlParameter("price", 40000));
foreach (var product in result)
{
Console.WriteLine(product.Name);
}
}
public static void DbContextDemo(KTStoreModel context)
{
var oq = context.Product.Where(p => p.Price > 1000 && p.Price < 50000);
Console.WriteLine(oq.ToString());
foreach (Product product in oq)
{
Console.WriteLine(product.Name);
}
}
public static void ObjectContextDemo(KTStoreModel context)
{
ObjectContext objectContext = (context as IObjectContextAdapter).ObjectContext;
ObjectSet <Product> products = objectContext.CreateObjectSet <Product>();
var oq = (ObjectQuery)products.Where(p => p.Price > 1000 && p.Price < 50000);
Console.WriteLine(oq.ToTraceString());
foreach (Product product in oq)
{
Console.WriteLine(product.Name);
}
}
public static void OldTest(KTStoreModel context)
{
context.Database.Log = Console.WriteLine;
ShowDBSetting(context);
//AddData(context);
var products = from p in context.Product select p;
foreach (var item in products)
{
Console.WriteLine($"{item.Name}:{item.Price}");
}
}
public static void DbSetUpdateDemo(KTStoreModel context)
{
var product = context.Product.First();
product.Price = 10000m;
context.SaveChanges();
context.Entry(product).Reload();
product = context.Product.First();
Console.WriteLine($"{product.Name}:{product.Price}");
product.Price = 39000m;
context.SaveChanges();
context.Entry(product).Reload();
product = context.Product.First();
Console.WriteLine($"{product.Name}:{product.Price}");
}
public static void DbSetRemoveDemo(KTStoreModel context)
{
var product = new Product() //跑錯棚的商品
{
Name = "統一科學麵",
Price = 20,
Quantity = 1
};
context.Product.Add(product); //做假資料
context.SaveChanges();
context.Entry(product).Reload();
var count = context.Product.Where(p => p.Name == "統一科學麵").Count();
Console.WriteLine($"資料筆數:{count}");
var removeData = context.Product.First(p => p.Name == "統一科學麵");
context.Product.Remove(removeData);
context.SaveChanges();
count = context.Product.Where(p => p.Name == "統一科學麵").Count();
Console.WriteLine($"資料筆數:{count}");
}