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