private void saveDBStoresLocally()
{
DiscountDataContext db = new DiscountDataContext();
var lStores = from c in db.Stores select c;
foreach (var i in lStores)
{
db.Stores.DeleteOnSubmit(i);
}
db.SubmitChanges();
foreach (CStore store_i in stores)
{
var store = new StoresTable();
store.storeID = store_i.storeID;
store.storeName = store_i.storeName;
db.Stores.InsertOnSubmit(store);
}
db.SubmitChanges();
}
private void saveDBStoresLocally()
{
DiscountDataContext db = new DiscountDataContext();
var lStores = from c in db.Stores select c;
foreach (var i in lStores)
{
db.Stores.DeleteOnSubmit(i);
}
db.SubmitChanges();
foreach (CStore store_i in stores)
{
var store = new StoresTable();
store.storeID = store_i.storeID;
store.storeName = store_i.storeName;
db.Stores.InsertOnSubmit(store);
}
db.SubmitChanges();
}
