By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,673 Members | 1,209 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,673 IT Pros & Developers. It's quick & easy.

SQL provider

P: n/a
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?
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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.
--
- Nicholas Paldino [.NET/C# MVP]
- ni**************@exisconsulting.com
"Duncan Winn" <te**@test1.co.uk> wrote in message
news:%2****************@tk2msftngp13.phx.gbl...
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?

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.