/// <summary>
/// Executes the query as a scalar
/// </summary>
/// <param name="query"></param>
/// <param name="returnInt"></param>
public static void ExecuteScalar(Query query, ref int? returnInt)
{
VerifyQueryObject(query);
ISqlQuery sqlClass = new SQLServer(GetConnectionString());
returnInt = sqlClass.ExecuteAsInt(query);
}
/// <summary>
/// Executes the query as a scalar
/// </summary>
/// <param name="query"></param>
///<param name="returnId></param>
public static void ExecuteScalar(Query query, ref Guid returnId)
{
VerifyQueryObject(query);
ISqlQuery sqlClass = new SQLServer(GetConnectionString());
returnId = (Guid)sqlClass.ExecuteAsScalar(query);
}
/// <summary>
/// Executes the query as a data table
/// </summary>
/// <param name="query"></param>
/// <param name="dataTableObject"></param>
public static void Execute(Query query, ref DataTable dataTableObject)
{
VerifyQueryObject(query);
ISqlQuery sqlClass = new SQLServer(GetConnectionString());
dataTableObject = sqlClass.ExecuteAsDataTable(query);
}
/// <summary>
/// Executes a sql xml query
/// </summary>
/// <param name="query"></param>
/// <param name="xmlString"></param>
public static void Execute(SqlXmlQuery query, ref string xmlString)
{
VerifySqlXmlQueryObject(query);
ISqlQuery sqlClass = new SQLServer(GetConnectionString());
xmlString = sqlClass.ExecuteXml(query);
}
/// <summary>
/// Executes the query
/// </summary>
/// <param name="query"></param>
public static void Execute(Query query)
{
VerifyQueryObject(query);
ISqlQuery sqlClass = new SQLServer(GetConnectionString());
sqlClass.Execute(query);
}