Women in Technology

Hear us Roar

  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.