|I know sql pretty well but am new to ado.net.
Can anyone suggest a quick reference on SQL commands and syntax that will work with ODBC or OleDb flat-files? Or that will work separately with non-SqlServer datasets in general?
For instance, I'd like to be able to use a t-sql style 'case-when-then' statement but am having no luck using it to pull records from a fixed-width text file I'm connecting to via an ODBC connection (a simple select with a where and order-by clause works fine).
My goal here is to be able to quickly find the syntax for all legal SQL statements within a given context, like any of us would expect with a regular t-sql manual, and know it will apply in a given environment.
I am not finding much help in the vs.net help files or web searches. Maybe I'm not looking in the right place or using the right search expressions? Everything seems to either be rudimentary select statements or assume you are using Sql Server databases.
In case it's helpful: I'm currently working on a console application in vb.net that needs to batch-process data in flat-files we get nightly, massaging the data with conditionals and some string manipulation, and updating other files. It should be possible to handle most of the process with a handful of SQL statements but I'm now looking at writing a bunch of nested vb routines instead. Not happy.
Thanks in advance for any help.