/// <summary>
/// Executes a sqlscript and returns a SQLDATAREADER
/// </summary>
/// <param name="hostName">Server name</param>
/// <param name="instanceName">Database Instance name</param>
/// <param name="databaseName">Database name</param>
/// <param name="sqlString">SQL statment</param>
public static void ExecuteSQlCommand(string hostName, string instalnceName, string databaseName, string sqlString)
{
using (SqlObjectWrapper sqlObjectWrapper = new SqlObjectWrapper(hostName, instalnceName, databaseName))
{
SqlDataReader dr = sqlObjectWrapper.ExecuteSqlCommands(sqlString);
// close the reader
dr.Close();
dr.Dispose();
}
}
/// <summary>
/// Checks if a result of a SQL statment exists
/// </summary>
/// <param name="hostName">Server name</param>
/// <param name="instanceName">Database Instance name</param>
/// <param name="databaseName">Database name</param>
/// <param name="sqlString">SQL statment</param>
/// <returns>True if the result exists, false otherwise</returns>
public static bool SqlObjectExists(string hostName, string instalnceName, string databaseName, string sqlString)
{
bool exists = false;
using (SqlObjectWrapper sqlObjectWrapper = new SqlObjectWrapper(hostName, instalnceName, databaseName))
{
using (SqlDataReader dr = sqlObjectWrapper.ExecuteSqlCommands(sqlString))
{
exists = dr.HasRows;
}
}
return(exists);
}
/// <summary>
/// Checks if a result of a SQL statment exists
/// </summary>
/// <param name="hostName">Server name</param>
/// <param name="instanceName">Database Instance name</param>
/// <param name="databaseName">Database name</param>
/// <param name="sqlString">SQL statment</param>
/// <returns>True if the result exists, false otherwise</returns>
public static bool SqlObjectExists(string hostName,string instalnceName, string databaseName, string sqlString)
{
bool exists = false;
using (SqlObjectWrapper sqlObjectWrapper = new SqlObjectWrapper(hostName, instalnceName, databaseName))
{
using (SqlDataReader dr = sqlObjectWrapper.ExecuteSqlCommands(sqlString))
{
exists = dr.HasRows;
}
}
return exists;
}
/// <summary>
/// Executes a sqlscript and returns a SQLDATAREADER
/// </summary>
/// <param name="hostName">Server name</param>
/// <param name="instanceName">Database Instance name</param>
/// <param name="databaseName">Database name</param>
/// <param name="sqlString">SQL statment</param>
public static void ExecuteSQlCommand(string hostName, string instalnceName, string databaseName, string sqlString)
{
using (SqlObjectWrapper sqlObjectWrapper = new SqlObjectWrapper(hostName, instalnceName, databaseName))
{
SqlDataReader dr = sqlObjectWrapper.ExecuteSqlCommands(sqlString);
// close the reader
dr.Close();
dr.Dispose();
}
}