public void Select_User()
{
using (var db = new OUT_SOURCE_DBEntities())
{
var users = db.Users;
foreach (var u in users)
{
Console.WriteLine(u.Name);
}
}
}
public void Select_User_Where()
{
using (var db = new OUT_SOURCE_DBEntities())
{
var users = db.Users.Where(u => u.Id == 1).Single();
Console.WriteLine(users.Id);
Console.WriteLine(users.Name);
Console.WriteLine(users.UpdateTime);
}
}
public void Test_User_Data_Insert()
{
Users user = new Users();
user.Address = "台北市中山區";
user.Name = "黃小名";
user.Email = "*****@*****.**";
user.CellPhone = "0912123123";
user.CreateTime = DateTime.Now;
user.UpdateTime = DateTime.Now;
using (var db = new OUT_SOURCE_DBEntities())
{
db.Users.Add(user);
db.SaveChanges();
}
using (var db = new OUT_SOURCE_DBEntities())
{
user.Name = "黃大名";
db.Users.Add(user);
db.SaveChanges();
}
}
