/// <summary>
/// 数据库初始化
/// </summary>
public static void CreateDatabaseIfNotExists( )
{
//运行的时候
Database.SetInitializer(new CreateDatabaseIfNotExist());
using (var mesContext = new MesContext())
{
mesContext.Database.Initialize(false);
}
}
public static void DropCreateDatabaseIfModelChanges()
{
//运行的时候
//Database.SetInitializer(new SampleData());
//开发的时候
Database.SetInitializer(new DropCreateDatabaseIfModel());
using (var mesContext = new MesContext())
{
mesContext.Database.Initialize(false);
}
}
private static void Method17()
{
using (var context = new MesContext("MesTest2"))
{
context.Database.Log = Console.Write;
User user = new User { usercode = "65128044", userpwd = "123", AddDate = DateTime.Now, eattribute1 = "123", IsDeleted = false, mdate = DateTime.Now, muser = "******", userdepart = "123", useremail = "123", username = "******", userstat = "123", usertel = "123" } ;
context.Users.Add(user);
//EntityState state = context.Entry(user).State;
//if (state == EntityState.Detached)
//{
// context.Entry(user).State = EntityState.Added;
//}
var students = from u in context.Users.Local where u.usercode == "65128044" select u;
var students2 = from u in context.Users where u.usercode == "65128044" select u;
students.First();
// context.SaveChanges();
}
}
//同步修改
private static void Method05()
{
OperationResult result2 = _container.GetExportedValueOrDefault<ContainerIn>().UserContract.FindEntity("65128044");
User user = (User)result2.AppendData;
user.userpwd = "444";
using (var mesContext=new MesContext()){
mesContext.Database.ExecuteSqlCommand("update Users set userpwd='333' where usercode='65128044'");
}
OperationResult result = _container.GetExportedValueOrDefault<ContainerIn>().UserContract.UpdateEntity(user);
Console.WriteLine(result.Message);
Console.WriteLine();
}
