Class for wrapping the .NET "System.Data.SqlClient" commands and gives an object oriented interface for easy database querying.
This class was made because of the need to have one code for several similar projects and to avoid repetition and for the ease of edit and maintenance.
This class was made before I hear with "SQLinq" and "Entity Framework" and even after using those I found it much simple and easier.
After using it for several years I found it very useful and decided to share it with others.
Individual Programmer since 23 years,
Main development language is VB.net,
Main development stream is web based applications.
Very like the similarity of Life and programming, Specially this one:
- Object oriented interface
- Easy to use (Just filling a list of commands and execute)
- Query builder
- Preventing SQL injection
- Preventing numeric field Overflow
- Preventing string field max length exceeding
- One line database query
- Free database query
- Tables join
- Most use query commands (And, Or, Like, In, ...)
The "SqlWrapTest" project in the solution is an example for how to use this class.
It is a winform project using the "Northwind" database and it must be installed on your device befor using this project.
You cand download this database from the following link:
https://github.com/Microsoft/sql-server-samples/tree/master/samples/databases/northwind-pubs
Please refer to the following explanation article:
https://www.codeproject.com/Articles/5061289/SQL-Wrapping-Class