//Methods private List <Character> GetCharacters() { var l = new List <Character>(); string query = "SELECT * FROM Characters"; using (var db = new TekkenEntity(SqliteConnectionString.ConnectionString)) { l = db.Database.SqlQuery <Character>(query).ToList(); } return(l); }
private List <Moves> GetMoves() { if (SelectedCharacter == null) { return(null); } var l = new List <Moves>(); string query = $"SELECT * FROM Moves WHERE CharacterId = {SelectedCharacter.Id}"; using (var db = new TekkenEntity(SqliteConnectionString.ConnectionString)) { l = db.Database.SqlQuery <Moves>(query).ToList(); } return(l); }
public static void CleanData() { using (var db = new TekkenEntity(SqliteConnectionString.ConnectionString)) { try { string dropQuery = "DROP TABLE IF EXISTS NewMoveList;"; db.Database.ExecuteSqlCommand(dropQuery); for (int i = 0; i < 1; i++) { } } catch (Exception e) { Console.WriteLine(e.Message); } } }