Query validation using C#

by

If you want to validate SQL syntax without the use of a database, the TSql100Parser class will do well for this situation.

Disclaimer, code borrowed from this post here Code to validate SQL Scripts

Pretty straightforward to use though. If it returns null, then there were no errors in parsing it.

using Microsoft.Data.Schema.ScriptDom;
using Microsoft.Data.Schema.ScriptDom.Sql;

public class SqlParser
{
        public List<string> Parse(string sql)
        {
            TSql100Parser parser = new TSql100Parser(false);
            IScriptFragment fragment;
            IList<ParseError> errors;
            fragment = parser.Parse(new StringReader(sql), out errors);
            if (errors != null && errors.Count > 0)
            {
                List<string> errorList = new List<string>();
                foreach (var error in errors)
                {
                    errorList.Add(error.Message);
                }
                return errorList;
            }
            return null;
        }
}

More Related Contents:

  1. How can I round a value in SQL
  2. How do I update a value in C# and SQL Server? [closed]
  3. SQL Server Char/VarChar DateTime Error [closed]
  4. Delete from two tables? [closed]
  5. How to get last inserted id?
  6. What are the pros and cons to keeping SQL in Stored Procs versus Code [closed]
  7. Execute Insert command and return inserted Id in Sql
  8. Adding multiple parameterized variables to a database in c#
  9. What represents a double in sql server?
  10. Passing List to SQL Stored Procedure
  11. SQL WHERE clause matching values with trailing spaces
  12. How to retrieve data from a SQL Server database in C#?
  13. SqlBulkCopy from a List
  14. Code to validate SQL Scripts
  15. What’s the fastest way to bulk insert a lot of data in SQL Server (C# client)
  16. SqlConnection.Close() inside using statement
  17. Generate class from database table
  18. ALTER TABLE DROP COLUMN failed because one or more objects access this column
  19. When executing a stored procedure, what is the benefit of using CommandType.StoredProcedure versus using CommandType.Text?
  20. Can I use ADFS 2.0 to authenticate certain users against SQL Server?
  21. ExecuteNonQuery returning -1 when using sql COUNT despite the query string
  22. What is passing parameters to SQL and why do I need it?
  23. The variable name ‘@’ has already been declared. Variable names must be unique within a query batch or stored procedure
  24. Add WHERE clauses to SQL dynamically / programmatically
  25. How to pass string array in SQL parameter to IN clause in SQL
  26. How to pass a null variable to a SQL Stored Procedure from C#.net code
  27. Database Error: There is no row at position 0
  28. Generating sql code programmatically
  29. Capturing count from an SQL query
  30. What does a timestamp in T-Sql mean in C#?

Leave a Comment