public void Execute(Data.Entities.Configuration configuration)
{
using (var cnn = CreateConnection())
{
try
{
cnn.Execute(@"UPDATE Configuration
SET Value = @Value, Name = @Name
WHERE ConfigurationId = @ConfigurationId", new
{
configuration.Value,
configuration.Name,
configuration.ConfigurationId
});
}
catch (DbException exception)
{
throw new UpdateConfigurationException(exception);
}
}
}
public void Execute(Data.Entities.Configuration configuration)
{
using (var cnn = CreateConnection())
{
try
{
configuration.ConfigurationId =
cnn.Query <int>(@"INSERT INTO Configuration (Value, Name, ApplicationId)
VALUES (@Value, @Name, @ApplicationId);
SELECT SCOPE_IDENTITY();", new
{
configuration.Value,
configuration.Name,
configuration.ApplicationId
}).First();
}
catch (DbException exception)
{
throw new CreateConfigurationException(exception);
}
}
}
