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();
}
}