private void DeleteCountry(int id) { using (WpContext context = new WpContext(connStr)) { if (!context.DatabaseExists()) { context.CreateDatabase(); } IQueryable <Country> query = from c in context.Countrys where c.CountryID == id select c; Country count = query.FirstOrDefault(); context.Countrys.DeleteOnSubmit(count); context.SubmitChanges(); } }
private void CreateDatabase(string name) { using (WpContext context = new WpContext(connStr)) { if (!context.DatabaseExists()) { context.CreateDatabase(); } Country model = new Country { CountryName = name }; context.Countrys.InsertOnSubmit(model); context.SubmitChanges(); } }