ONJava.com -- The Independent Source for Enterprise Java
oreilly.comSafari Books Online.Conferences.


AddThis Social Bookmark Button
  Transparent Database Access with ADO.NET
Subject:   Parameters
Date:   2003-02-06 10:25:06
From:   neh123us@yahoo.com
Response to: Parameters

A good way to hide such differences in the SQL syntax is to use stored procedures and bind parameters using the IDbDataParameter interface. Another method would be to store the parameter prefix character in a config file, but this would not abstract the differences in join syntax, set operations, and other vendor specific syntax.

I hope this helps.