private async Task <bool> ExecuteSql(string connectionString)
{
using (SqlCeConnection sqlCeConnection = new SqlCeConnection(connectionString))
{
sqlCeConnection.Open();
using (SqlCeTransaction sqlCeTransaction = sqlCeConnection.BeginTransaction())
{
string sqlData = await SqlEngineProvider.GetSqlDataAsync();
string[] sqlStatements = sqlData.Split(_sqlSeparator, StringSplitOptions.RemoveEmptyEntries);
foreach (var sqlStatement in sqlStatements)
{
using (SqlCeCommand sqlCeCommand = sqlCeConnection.CreateCommand())
{
sqlCeCommand.Transaction = sqlCeTransaction;
sqlCeCommand.CommandText = sqlStatement;
sqlCeCommand.ExecuteNonQuery();
}
}
sqlCeTransaction.Commit();
}
return(true);
}
}
private static async Task <bool> InsertImagesAsync(string connectionString)
{
string sqlCommand = await SqlEngineProvider.GetImageInsertCommandAsync();
using (SqlCeConnection sqlCeConnection = new SqlCeConnection(connectionString))
{
sqlCeConnection.Open();
using (SqlCeTransaction sqlCeTransaction = sqlCeConnection.BeginTransaction())
{
// dark souls3
byte[] darkSouls3Resource = await ImageResource.GetDarkSouls3ImageResourceAsync();
ExecuteSqlCommandWithParameters(DarkSouls3GameName, darkSouls3Resource, sqlCeConnection, sqlCommand, sqlCeTransaction);
// Sekiro
byte[] sekiroResource = await ImageResource.GetSekiroImageResourceAsync();
ExecuteSqlCommandWithParameters(SekiroGameName, sekiroResource, sqlCeConnection, sqlCommand, sqlCeTransaction);
sqlCeTransaction.Commit();
return(true);
}
}
}