public void UpdateTareas(Tareas Tareas) { using (var db = new EntityFrameworkSQLite()) { db.Tarea.Update(Tareas); var count = db.SaveChanges(); } }
public static void Main() { using (var db = new EntityFrameworkSQLite()) { ICollection <ChatMessage> messages = new Collection <ChatMessage>(); var message = new ChatMessage(); message.id = 15; message.idUser = 16; message.message = "HI"; messages.Add(message); message.id = 7; message.idUser = 1; message.message = "How r u"; messages.Add(message); db.User.Add(new chatUser { id = 13, email = "*****@*****.**", messages = messages }); var count = db.SaveChanges(); Console.WriteLine("{0} records saved to database", count); Console.WriteLine(); Console.WriteLine("All blogs in database:"); foreach (var blog in db.User) { Console.WriteLine(" - {0}", blog.email); } } ////try ////{ //// using (var db = new SQLiteConnection(@"Data Source=C:\Jalasoft\Git\jalasoft\BackEnd-Orlando\Jalasoft.BackEnd\Jalasoft.BackEnd.Console\bin\Debug\netcoreapp2.2\Chat.db")) //// { //// if (!File.Exists(@"Data Source=C:\Jalasoft\Git\jalasoft\BackEnd-Orlando\Jalasoft.BackEnd\Jalasoft.BackEnd.Console\bin\Debug\netcoreapp2.2\Chat.db")) //// { //// CreateDatabase(); //// } //// db.Open(); //// chatUser chatUser = new chatUser(); //// chatUser.id = 7; //// chatUser.email = "Roger Ruiz"; //// var a = db.Query<int>( //// @"INSERT INTO User (email) VALUES (@email ); //// ", chatUser); //// Console.WriteLine("el dato insertado es" + a.ToString()); //// } ////} ////catch (Exception ex) ////{ //// Console.WriteLine(ex.ToString()); ////} }
public List <chatUser> GetAll() { using (var db = new EntityFrameworkSQLite()) { var a = db.User.ToList() as List <chatUser>; return(a); } throw new NotImplementedException(); }