public ExecuteScalarInteger ( AliaSQL.Core.Model.ConnectionSettings settings, string sql ) : int | ||
settings | AliaSQL.Core.Model.ConnectionSettings | |
sql | string | |
return | int |
public int ExecuteScalarInteger(ConnectionSettings settings, string sql)
{
string connectionString = _connectionStringGenerator.GetConnectionString(settings, true);
using (var connection = new SqlConnection(connectionString))
{
connection.Open();
using (var command = new SqlCommand())
{
command.Connection = connection;
command.CommandText = sql;
return Convert.ToInt32(command.ExecuteScalar());
}
}
}