static void Main(string[] args)
{
var context = new MyContext();
User[] users = context.Users.ToArray();
foreach (var user in users)
{
Console.WriteLine(user.ID + ", " + user.Name);
}
}
private static void UpdateWithSelecting(MyContext context)
{
UserDTO dto = new UserDTO()
{
id = 2,
name = "XXX",
};
User user = new User()
{
ID = dto.id,
};
DbEntityEntry entry = context.Entry(user);
entry.State = EntityState.Unchanged;
user.Name = dto.name;
context.SaveChanges();
}
static void Main(string[] args)
{
using (MyContext context = new MyContext())
{
context.Users.ToArray();
//UpdateWithSelecting(context);
//foreach (Group group in context.Groups.Include("Users"))
//{
// Console.WriteLine(group.Name);
// foreach (var user in group.Users)
// {
// Console.WriteLine(" " + user.Name);
// }
//}
}
}
private static void CreateData(MyContext context)
{
User user = new User()
{
Name = "Ori"
};
Group group = new Group()
{
Name = "Friends",
Users = new List<User>(),
};
context.Groups.Add(group);
group.Users.Add(user);
context.SaveChanges();
}
private static void AddMoreData(MyContext context)
{
//Group group = context.Groups.Where(g => g.Name == "Friends").Single();
Group group = (from g in context.Groups where g.Name == "Friends" select g).Single();
User user = new User()
{
Name = "Roni",
};
group.Users.Add(user);
context.SaveChanges();
}
