Parse Transact SQL to Check Syntax

Andre Pieterse

Rate me:

4.37/5 (13 votes)

12 Jan 2022CPOL13 min read

85.2K

2.2K

How to implement a parse function within a C# WPF application

This article addresses the problem of how to pass some Transact-SQL text to a specified SQL Server instance, and ask it to parse the code, returning any syntax errors.

TSqlConsole.zip
- TSqlConsole.sln
- TSqlConsole.suo
- TSqlConsole
  - App.xaml
  - App.xaml.cs
  - ConnectWindow.xaml
  - ConnectWindow.xaml.cs
  - Images
    - application_xp_terminal.png
    - bug.png
    - bullet_blue.png
    - bullet_red.png
    - cut.png
    - database.png
    - database_connect.png
    - database_table.png
    - disconnect.png
    - disk.png
    - folder_page.png
    - lightning.png
    - page_white_copy.png
    - page_white_paste.png
  - MainWindow.xaml
  - MainWindow.xaml.cs
  - Properties
  - ResultWindow.xaml
  - ResultWindow.xaml.cs
  - SqlHandler.cs
  - TSqlConsole.csproj
  - TSqlConsole.csproj.user

By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.

If a file you wish to view isn't highlighted, and is a text file (not binary), please let us know and we'll add colourisation support for it.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Written By

Andre Pieterse

Software Developer

South Africa

I have a bachelor's degree in BCOM Economics and Informatics.

I have worked mainly in the financial services industry, developing and supporting software for major financial institutions.

My main focus is on .Net technologies including C#, WPF, ASP.Net, SQL Server, etc.

Parse Transact SQL to Check Syntax

License

Comments and Discussions