private void btnTest_Click(object sender, RoutedEventArgs e) { Client client = new Client { NameEng = "testUser1" }; using (var context = new EntitiesContext()) { context.Clients.Add(client); context.SaveChanges(); } }
public ObservableCollection<Client> GetClients() { var clients = new ObservableCollection<Client>(); using (var context = new EntitiesContext()) { foreach (var item in context.Clients) { clients.Add(item); } } return clients; }
public void SaveClient(Client client) { using (var context = new EntitiesContext()) { if (client.ClientID != 0) { context.Entry(client).State = EntityState.Modified; } else { context.Entry(client).State = EntityState.Added; } context.SaveChanges(); } }
public Client GetClient(int clientId) { Client client; using (var context = new EntitiesContext()) { client = (from c in context.Clients where c.ClientID == clientId select c).FirstOrDefault(); } return client; }
public ObservableCollection<Case> GetCases() { var cases = new ObservableCollection<Case>(); using (var context = new EntitiesContext()) { foreach (var item in context.Cases) { cases.Add(item); } } return cases; }