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