|
using System.Collections.Generic;
namespace Application.DAL.Contract
{
/// <summary>
/// Base contract for support 'dialect specific queries'.
/// </summary>
public interface ISql
{
/// <summary>
/// Execute specific query with underliying persistence store
/// </summary>
/// <typeparam name="T">Entity type to map query results</typeparam>
/// <param name="sqlQuery">
/// Dialect Query
/// <example>
/// SELECT idCustomer,Name FROM dbo.[Customers] WHERE idCustomer > {0}
/// </example>
/// </param>
/// <param name="parameters">A vector of parameters values</param>
/// <returns>
/// Enumerable results
/// </returns>
IEnumerable<T> ExecuteQuery<T>(string sqlQuery, params object[] parameters);
/// <summary>
/// Execute arbitrary command into underliying persistence store
/// </summary>
/// <param name="sqlCommand">
/// Command to execute
/// <example>
/// SELECT idCustomer,Name FROM dbo.[Customers] WHERE idCustomer > {0}
/// </example>
///</param>
/// <param name="parameters">A vector of parameters values</param>
/// <returns>The number of affected records</returns>
int ExecuteCommand(string sqlCommand, params object[] parameters);
}
}
|
By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.
If a file you wish to view isn't highlighted, and is a text file (not binary), please
let us know and we'll add colourisation support for it.
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.