public int ExecuteNonQuery(string sql)
{
using (var connection = sqlConnectionFactory.Create())
{
var command = new SqlCommand(cmdText: sql, connection: connection);
return(command.ExecuteNonQuery());
}
}
public IEnumerable <dynamic> ExecuteReader(string sql)
{
using (var connection = sqlConnectionFactory.Create())
{
var command = new SqlCommand(cmdText: sql, connection: connection);
var dataReader = command.ExecuteReader();
while (dataReader.Read())
{
yield return(dataReader.ToDynamic());
}
}
}
