/// <summary> /// /// </summary> /// <param name="query"></param> /// <param name="parameter"></param> public Query(string query, ISqlParameter parameter) { Connection = Sql.Connection; Command = new SqlCommand(query, Connection); var parameters = parameter?.GetParameters(); if (parameters != null) { Command.Parameters.AddRange(parameters); } }
/// <summary> /// /// </summary> /// <param name="name"></param> /// <param name="parameter"></param> public StoredProcedure(string name, ISqlParameter parameter) { Connection = Sql.Connection; Command = new SqlCommand(name, Connection) { CommandType = CommandType.StoredProcedure }; var parameters = parameter?.GetParameters(); if (parameters != null) { Command.Parameters.AddRange(parameters); } }