private static void ReadAll() { using (var context = new TerminalDB2Entities()) { var query = from s in context.Terminal orderby s.Id select s; foreach (var item in query) { Console.WriteLine("{0}\t{1}\t{2}", item.message, item.datetime, item.topic); } } }
private static void Insert() { using (var context = new TerminalDB2Entities()) { Terminal terminal = new Terminal { message = "OFF ---", datetime = DateTime.Now.ToString("MM/dd/yyyy hh:mm:ss.fff tt"), topic = "/terminal-insert" }; context.Terminal.Add(terminal); context.SaveChanges(); } }