public static void CreateBD(DbContext context)
{
try
{
context.Database.CreateIfNotExists();
if (!context.Database.CompatibleWithModel(throwIfNoMetadata: true))
{
throw new Exception("Delete and Create DataBase");
}
}
catch
{
try
{
My.DeleteBD(context);
}
catch (Exception e)
{
using (var commande = new SqlCommand("ALTER DATABASE " + DataBaseName + " SET SINGLE_USER WITH ROLLBACK IMMEDIATE;DROP DATABASE " + DataBaseName + " ;", new SqlConnection(My.ConnectionString)))
{
commande.Connection.Open();
commande.ExecuteNonQuery();
}
}
context.Database.CreateIfNotExists();
}
}
public static void Execute()
{
// Create BD
using (var context = new EntityContext())
{
My.CreateBD(context);
}
// CLEAN
using (var context = new EntityContext())
{
context.EntitySimples.RemoveRange(context.EntitySimples);
context.EntitySimpleChilds.RemoveRange(context.EntitySimpleChilds);
context.EntitySimpleLists.RemoveRange(context.EntitySimpleLists);
context.SaveChanges();
}
var entity = new EntitySimple {
ColumnInt = 0
};
// SEED
using (var context = new EntityContext())
{
context.EntitySimples.Add(entity);
context.SaveChanges();
}
entity.EntitySimpleChild = new EntitySimpleChild()
{
ColumnInt = 1
};
entity.EntitySimpleLists = new List <EntitySimpleList>()
{
new EntitySimpleList()
{
ColumnInt = 2
}, new EntitySimpleList()
{
ColumnInt = 3
}
};
// TEST
using (var context = new EntityContext())
{
context.UpdateGraph(entity, map => map.AssociatedEntity(c => c.EntitySimpleChild).AssociatedCollection(c => c.EntitySimpleLists));
context.SaveChanges();
}
using (var context = new EntityContext())
{
var a = context.EntitySimples.ToList();
var b = context.EntitySimpleChilds.ToList();
var c = context.EntitySimpleLists.ToList();
}
}
public static void Execute()
{
// Create BD
using (var context = new EntityContext())
{
My.CreateBD(context);
}
// CLEAN
using (var context = new EntityContext())
{
context.EntitySimples.RemoveRange(context.EntitySimples);
context.EntitySimpleChilds.RemoveRange(context.EntitySimpleChilds);
context.EntitySimpleLists.RemoveRange(context.EntitySimpleLists);
context.SaveChanges();
}
var entity = new EntitySimple {
ColumnInt = 0
};
// SEED
using (var context = new EntityContext())
{
entity.EntitySimpleChild = new EntitySimpleChild()
{
ColumnInt = 1
};
var EntitySimpleLists = new List <EntitySimpleList>()
{
new EntitySimpleList()
{
ColumnInt = 2
}, new EntitySimpleList()
{
ColumnInt = 3
}
};
context.EntitySimples.Add(entity);
context.EntitySimpleLists.AddRange(EntitySimpleLists);
context.SaveChanges();
}
EntitySimpleList entityChildList = null;
using (var context = new EntityContext())
{
entity = context.EntitySimples.Include(x => x.EntitySimpleChild).First();
entityChildList = context.EntitySimpleLists.First();
entity.EntitySimpleLists = new List <EntitySimpleList>()
{
entityChildList
};
}
entityChildList.ColumnInt = 20;
entityChildList.EntitySimpleList2s = new List <EntitySimpleList2>()
{
new EntitySimpleList2()
};
// TEST
using (var context = new EntityContext())
{
context.UpdateGraph(entity, map => map.AssociatedEntity(c => entity.EntitySimpleLists).AssociatedCollection(c => c.EntitySimpleLists));
//context.UpdateGraph(entity.EntitySimpleLists.First(), map => map.AssociatedEntity(c => c.EntitySimpleList2s));
context.SaveChanges();
}
using (var context = new EntityContext())
{
var a = context.EntitySimples.ToList();
var b = context.EntitySimpleChilds.ToList();
var c = context.EntitySimpleLists.ToList();
}
}
public static void Execute()
{
// Create BD
using (var context = new EntityContext())
{
My.CreateBD(context);
}
// CLEAN
using (var context = new EntityContext())
{
context.EntitySimples.RemoveRange(context.EntitySimples);
context.EntitySimpleChilds.RemoveRange(context.EntitySimpleChilds);
context.EntitySimpleLists.RemoveRange(context.EntitySimpleLists);
context.SaveChanges();
}
var entity = new EntitySimple {
ColumnInt = 0
};
// SEED
using (var context = new EntityContext())
{
context.EntitySimples.Add(entity);
context.SaveChanges();
}
entity.EntitySimpleChild = new EntitySimpleChild()
{
ColumnInt = 1
};
entity.EntitySimpleLists = new List <EntitySimpleList>()
{
new EntitySimpleList()
{
ColumnInt = 2
}, new EntitySimpleList()
{
ColumnInt = 3
}
};
// TEST
using (var context = new EntityContext())
{
// var node1 = context.UpdateGraph(entity, map => map.OwnedEntity(p => p.EntitySimpleChild, (Expression<Func<IUpdateConfiguration<EntitySimpleChild>, object>>) with =>
// with.OwnedCollection(p => p.EntitySimples)));
// context.UpdateGraph(entity, map => map.AssociatedEntity(c => c.EntitySimpleChild).AssociatedCollection(c => c.EntitySimpleLists, x => x.B));
context.UpdateGraph(entity, map => map.AssociatedCollection(c => c.EntitySimpleLists, x => x.B).AssociatedEntity(c => c.EntitySimpleChild));
//context.UpdateGraph(entity, map => map.AssociatedEntity(c => c.EntitySimpleChild).AssociatedCollection(c => c.EntitySimpleLists));
//context.UpdateGraph(entity, map => map.OwnedEntity(c => c.EntitySimpleChild).OwnedCollection(c => c.EntitySimpleLists));
context.SaveChanges();
}
entity = new EntitySimple {
ColumnInt = 101
};
using (var context = new EntityContext())
{
entity.EntitySimpleChild = new EntitySimpleChild()
{
ColumnInt = 1
};
entity.EntitySimpleLists = new List <EntitySimpleList>()
{
new EntitySimpleList()
{
ColumnInt = 2
}, new EntitySimpleList()
{
ColumnInt = 3
}
};
context.EntitySimples.Add(entity);
context.SaveChanges();
}
using (var context = new EntityContext())
{
var a = context.EntitySimples.ToList();
var b = context.EntitySimpleChilds.ToList();
var c = context.EntitySimpleLists.ToList();
}
}
