DownloadThe Crud Class Generator tool was developed for .Net to generate the class, which is an object model of a database table. Thanks to these created classes, many CRUD operations can be performed without writing a SQL query.
*CCG is easy to use, because; it is developer-friendly
*CCG is practical, because; it allows to make many crud processes without writing SQL query
*CCG is fast because; The object size is very small and allowing multiple simultaneous operations to be performed by going to the database only once.
To get help about CCG please visit http://ccg.snazzydocs.com/
You can send your questions and suggestions to ccg4dal@gmail.com
Do not forget to leave comments about the application. Thus, you will motivate me to further develop the application. Also, do not hesitate to ask me any questions you may have.
NOTE: To be able to use the generated classes in your project, don't forget to download and reference the Required_Files.
Features
- It has a simple and easy-to-use interface
- Generated classes are easy to use and performant
- In addition to the CRUD class, the Interface class can also be generated
- Parameter class can be generated as a separate file or inside a CRUD or Interface class
- It can be ensured that only methods related to SELECT operations are found in the generated CRUD class
- CRUD operations can be logged. For example, the state of the deleted record before it was deleted or the state of a changed record before it was changed can be recorded in the log.
- Both ADO and SQL transaction can be used
- AdHoc query can be run and this query can be logged
- Stored Procedure can be called
- Multiple generated insert commands can be sent to the database in bulk
- More than one command prepared for different operations can be sent to the database at the same time. For example, insert, update, delete and select commands can be sent to the database in one transaction at the same time
- During the CRUD process, the database name, connection string name and command timeout can be changed
- Dataset can be returned in DataTable type or class type
- Aggregate functions such as MIN, MAX, SUM, AVG, COUNT can be used
- If the relationships between the tables are defined correctly, the data can be queried during the select operation as detail tables, related tables, look-up tables or all tables joined.
- Joining is also possible for tables that are not physically related
- The WHERE condition or the conjunction (AND, OR) operators within the condition can be changed
- Support MS-SQL AlwaysOn ROR (Read Only Routing) feature. Just add ApplicationIntent=ReadOnly to your connection string and then CCG will send "Select" commands to secondary nodes.
- Enums can be automaticly generated from Lookup or other tables with all data or partial data by writing sql query.
- Connection string can be read from config file or from registry. Also, all connection string or just user password in connection string can be encrypted and decrypted by using CCGHelper
- Moreover; You can use the CCGHelper library, which contains many helper methods and allows you to easily perform operations in one line, in any of your .Net projects
- Prevents SQL Injections
- You can generate CRUD classes by selecting as many tables as you want at the same time.
- For now, it only works with MS SQL Server database, but it is still working to work with Oracle database
Project Samples
License
MIT LicenseFollow CCG
User Reviews
-
I have used it in many small, medium and large-scale projects so far and I continue to use it in every new project. With this tool, you don't have to worry about the data access layer. You design your database, generate the tables and start writing your code directly.