public Album getObject(int ind) { //string searchString = TextBox7.Text; var q = from c in svc.CreateQuery <Album>("ProductTable2") select c; int mycount = 0; index = ind; foreach (var p in q) { if (mycount == ind) { return((Album)p); } //if (p.Item.Equals(searchString)) mycount++; } return(null); }
public void delete_all() { var q = from c in svc.CreateQuery <Album>("ProductTable2") select c; foreach (var p in q) { svc.DeleteObject(p); } svc.SaveChanges(); }