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();
}
}
private void SearchCountry(string name = "")
{
using (WpContext context = new WpContext(connStr))
{
if (!context.DatabaseExists())
{
context.CreateDatabase();
}
IQueryable <Country> query;
if (!string.IsNullOrEmpty(name))
{
query = from c in context.Countrys where c.CountryName.Contains(name) select c;
}
else
{
query = from c in context.Countrys select c;
}
List <Country> list = query.ToList <Country>();
listBox1.ItemsSource = list;
}
}