Handels operation with SQL Server. Uses currently ADO.NET for connection.
The Class is implementet as Singleton Pattern.
Methods:*GetInstance() returns the Singleton Instance of this class.
- CallProcedureSelect(SqlCommand cmd, XPathDocument xsl) returns a XPathDocument.
Fill the commandtext property of the SqlCommand with the Procedurename.
The method will transform the result of the db with an xsl document.
Other Overloadings: public XPathDocument CallProcedureSelect(SqlCommand cmd)
- GetObjectFromXml(XmlDocument doc, Type type) returns a object.
This method is an serialization helper.
- CallDirectSelect(string sql)
Invokes an sql statement on the database. The use of procedures is recommended.