How to delete record in SqlCe Db for windows phone

Question

Have two tables ;  Master  and child as below:

tblMaster
==========
MId
DateOfTransact
Note

tblChild
======
Cid
Mid
TypeOfTransaction
Time
Amount

Questions:

1. How to delete all the Records in Tables Master and child?

 

Answer 1

Get all records from tblChild, delete them, submitchanges, get all records fro tblMaster, delete them, submit changes. See some sample code here: http://erikej.blogspot.dk/2012/04/windows-phone-local-database-tip.html

---

Please mark as answer, if this was it. Visit my SQL Server Compact blog

Answer 2

Thanks for the link. Here the two methods.

Can use method 1 into Method 2 where :

context3.tblChild.DeleteOnSubmit(Rcd)  instead using foreach- statement?

===================

Method 1:
-----------
var list = db.InvoiceLine.Take(100);      
db.InvoiceLine.DeleteAllOnSubmit(list);

 

Method 2
-------------
  using (DbTransact  context3 = new DbTransact(ConnectionString))
 {          
 var Rcd = from c in tblChild                         
                where c.Mid == Convert.ToInt32(strIdNo)                         
                select c;

  foreach (var c in Rcd )
                    {
                        context3.tblChild.DeleteOnSubmit(c);
                    }

  context3.SubmitChanges();

}