Utils_Sql Methods

Checks if a column exists in a table of a database.

Ensures that a data reader is closed. Will not throw if the reader is null or already closed.

Ensures a column definition inside a SQL table.

Ensures a column index on a SQL table.

Note: for Packflow, the schema should be DBADMIN.

Ensures all indexes on a SQL table. Based on column definitions.

Ensures a table definition in a database.

Tries to obtain the .Net type corresponding to a SQL column type.

Generates an xml of all objects referenced by the connection.

IMPORTANT : USE ONLY FOR DEBUGGING PURPOSE !!!

http://blogs.msdn.com/b/dataaccesstechnologies/archive/2009/04/08/how-to-find-out-the-data-reader-referencing-an-ado-net-connection-object-to-fix-the-error-there-is-already-an-open-datareader-associated-with-this-command-which-must-be-closed-first.aspx

Gets the column names of a SQL table.

Checks if a SQL connection is closed (not open, closed, opening, or broken).

Checks if a SQL connection is open (not closed or broken).

Gets the key using Mica_GetPropertyValue.

Gets the string value of a property using reflection.

Gets the title using Mica_GetPropertyValue.

Checks if a table exists in a database.

Checks if a table exists in a database, in a given schema.

Checks if a table exists in a database, in a given schema.

Checks if a table exists in a database.