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