private static void Transaction() { LinqTdsDataContext dt = new LinqTdsDataContext(ConnString); try { int sender = SelectUser("Please select message sender"); int chatid = SelectChat("Please select chat to send message"); string message = Core.GetInput("Message"); db.GetTable <messages>().InsertOnSubmit(new messages() { sender = sender, chatId = chatid, message = message }); db.GetTable <messages>().InsertOnSubmit(new messages() { sender = sender, chatId = chatid, message = message + " _additional" }); db.SubmitChanges(ConflictMode.ContinueOnConflict); MenuManager.Menu(new string[] { "Go back" }, "Transaction successful!"); } catch (ChangeConflictException) { db.ChangeConflicts.ResolveAll(RefreshMode.OverwriteCurrentValues); Console.WriteLine("Conflict"); Console.ReadKey(true); } catch (Exception ex) { Console.WriteLine(ex.Message); foreach (ObjectChangeConflict item in db.ChangeConflicts) { item.Resolve(RefreshMode.KeepCurrentValues); } } }
public static void Init() { //SelectUser("test"); // cmd = new SqlCommand("SELECT * FROM accounts", connection); // adapter = new SqlDataAdapter(cmd); // connection.Open(); // adapter.Fill(ds, "accounts"); // cmd = new SqlCommand("SELECT * FROM Keys", connection); // adapter = new SqlDataAdapter(cmd); // adapter.Fill(ds, "Keys"); // connection.Close(); // Console.WriteLine("DataSet initialised!\r\nPress any key to continue. . ."); // Console.ReadKey(true); LinqTdsDataContext context = new LinqTdsDataContext(); //IEnumerable<accounts> accs = new /*var result = from accounts in ds.Tables["accounts"].AsEnumerable() * select accounts;*/ /*var result = from accounts in db.GetTable<accounts>() * select accounts;*/ Menu(); }