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();
}
}
