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