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.


Last edited Mar 8, 2010 at 5:33 PM by Wolf166, version 2

Comments

No comments yet.