SQL provider

[Duncan Winn]

I am WRITING (not using) an ADO.NET provider to provide access to my custom
data source (C++ classes). My clients are hoping to access the data in my
classes, through the provider, using SQL, however my data source does not
support SQL. Will I have to parse the SQL to get the relevant data from the
data source, or does the provider have classes or components that
automatically do this?

 

[Nicholas Paldino [.NET/C# MVP]]

Duncan,

You will have to do this yourself. The SQL provider might do some
parsing, but those APIs are not exposed, and a good part of the work is
being done on the server anyways. The provider is just issuing the commands
to the server.

You will want to write your own or find a third party component that
does this. You might be able to pick up the SQL 92 language specification
in BNF notation, and then run it through some sort of parser/analyzer to
generate classes that will do the parsing for you, creating programattic
representations of the language elements.

Hope this helps.