public Character LoadEntity(long id)
{
using (IDbConnection dbConnection = new SQLiteConnection(RepositoryUtil.LoadConnectionString()))
{
return(dbConnection.QuerySingleOrDefault <Character>("Select * From Characters Where Id = @Id", new { Id = id }));
}
}
public ObservableCollection <Character> LoadEntityCollection()
{
using (IDbConnection dbConnection = new SQLiteConnection(RepositoryUtil.LoadConnectionString()))
{
var output = dbConnection.Query <Character>("Select * From Characters");
return(new ObservableCollection <Character>(output));
}
}
public void Insert(Character entity)
{
using (IDbConnection dbConnection = new SQLiteConnection(RepositoryUtil.LoadConnectionString()))
{
string insertQuery = "INSERT INTO Characters(Name, Player, Age, Gender, Alignment) VALUES (@Name, @Player, @Age, @Gender, @Alignment)";
dbConnection.Execute(insertQuery, entity);
}
}
public void Delete(Character entity)
{
using (IDbConnection dbConnection = new SQLiteConnection(RepositoryUtil.LoadConnectionString()))
{
string deleteQuery = "Delete From Characters WHERE Id = @Id";
dbConnection.Execute(deleteQuery, new
{
entity.Id
});
}
}
public void Update(Character entity)
{
using (IDbConnection dbConnection = new SQLiteConnection(RepositoryUtil.LoadConnectionString()))
{
string insertQuery = "UPDATE Characters SET Name = @Name, Player = @Player, Age = @Age, Gender = @Gender, Alignment = @Alignment WHERE Id = @Id";
dbConnection.Execute(insertQuery, new
{
entity.Name,
entity.Player,
entity.Age,
entity.Gender,
entity.Alignment,
entity.Id
});
}
}
