validate sql syntax

[Jarod_24]

How do i check if a sql-string has corect syntax.

With select-statements you can just use a Datareader, since no data is changed in the database, but i'm working with other
statements as well, and need to just verify that the syntax of the string is correct, and determine if it is a select, update,
insert or delete statement.

I've looked but can't seem to find a class that does this.

 

[Sharon]

do you use a single method for all types of query?

How do i check if a sql-string has corect syntax.

With select-statements you can just use a Datareader, since no data is

changed in the database, but i'm working with other

statements as well, and need to just verify that the syntax of the string

is correct, and determine if it is a select, update,

 

[Jarod_24]

do you use a single method for all types of query?

?!?!
I am asking if there exists a method to do this.

 

[Sharon]

it is not clear from what you wrote, whether you are using
a single method for all types of data access,
or that you are trying to validate a query for a specific type of data
access
in a specific method.
usually different methods are used for different types of data access.
you don't even have to implement it.
check out Data Access Application Block for .NET:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnbda/html/daab-rm.asp