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