Hi GUys,
Does DOT NET framework (ADO.NET) provides a way for Early SQL validation? i.e. when we write the SQL in code usinlg ASQL command object or by any other means, it should perform syntactic validations
Printable View
Hi GUys,
Does DOT NET framework (ADO.NET) provides a way for Early SQL validation? i.e. when we write the SQL in code usinlg ASQL command object or by any other means, it should perform syntactic validations
I don't think ADO.NET does the syntax validation for the queries written directly in .NET.
I would suggest using Stored Procedures or parametrized queries for querying database. It would be easier and faster compared to the T-SQL that we write.