static void Main(string[] args) { var db = new dbDataContext(); var tb = db.tbCustomers; int count = tb.Count(); //Console.WriteLine(count); var list = (from u in tb select new { u.Fname, u.Lname, u.TelegramId, u.mobile }).Count(); Console.WriteLine("Count={0} ", list); var list2 = (from u in tb select new { u.Fname, u.Lname, u.TelegramId, u.mobile }); foreach (var r in list2) { Console.WriteLine("{0} {1} {2} {3}", r.Fname, r.Lname, r.mobile, r.TelegramId); } tbCustomer rb = new tbCustomer(); Console.Write("TelegramID="); rb.TelegramId = Convert.ToInt32(Console.ReadLine()); Console.Write("First Name="); rb.Fname = Console.ReadLine(); Console.Write("Last Name="); rb.Lname = Console.ReadLine(); Console.Write("Mobile="); rb.mobile = Console.ReadLine(); db.tbCustomers.InsertOnSubmit(rb); try { db.SubmitChanges(); Console.WriteLine("Record Added"); }catch (Exception e) { Console.WriteLine(e.Message); } Console.ReadLine(); }
partial void DeletetbCustomer(tbCustomer instance);
partial void UpdatetbCustomer(tbCustomer instance);
partial void InserttbCustomer(tbCustomer instance);