public async Task <int> UpdateCreationCount()
{
var characterCreationCount = 0;
var connectionString = await connectionStringResolver.ResolveConnectionString("DefaultConnectionString");
using (var connection = new SqlConnection(connectionString))
{
await connection.OpenAsync();
using (var command = new SqlCommand("Creation.GetCharacterCreationCount", connection))
{
command.CommandType = System.Data.CommandType.StoredProcedure;
using (var reader = await command.ExecuteReaderAsync())
{
while (await reader.ReadAsync())
{
characterCreationCount = reader.GetInt32(reader.GetOrdinal("CreationCount"));
}
}
}
}
return(characterCreationCount);
}
protected override ISqlConnection GetConnection(string connectionStringName)
{
ISqlConnection connection;
if (!Factories.TryGetValue(connectionStringName, out connection))
{
var connectionString = _connectionStringResolver.ResolveConnectionString(connectionStringName);
connection = new SqlConnection(() => new SqliteConnection(connectionString));
}
return(connection);
}
public async Task Save(Character character, Guid creatorId)
{
using (var connection = new SqlConnection(await connectionStringResolver.ResolveConnectionString("DefaultConnectionString")))
{
await connection.OpenAsync();
using (var command = new SqlCommand("Character.AddCharacter", connection))
{
command.CommandType = System.Data.CommandType.StoredProcedure;
command.Parameters.AddWithValue("@Id", Guid.NewGuid());
command.Parameters.AddWithValue("@CreatorId", creatorId);
command.Parameters.AddWithValue("@Blob", JsonConvert.SerializeObject(character));
await command.ExecuteNonQueryAsync();
}
}
}
protected override ISqlConnection GetConnection(string connectionStringName)
{
ISqlConnection connection;
if (Factories.TryGetValue(connectionStringName, out connection))
{
return(connection);
}
var connectionString = _connectionStringResolver.ResolveConnectionString(connectionStringName);
connection = new SqlConnection(() =>
{
var c = new System.Data.SqlClient.SqlConnection(connectionString);
c.Open();
return(c);
});
return(connection);
}