Ejemplo n.º 1
0
 /// <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);
 }
Ejemplo n.º 2
0
 /// <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);
 }
Ejemplo n.º 3
0
 /// <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);
 }
Ejemplo n.º 4
0
 /// <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);
 }
Ejemplo n.º 5
0
 /// <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);
 }