SQL To CSharp Plus

Purpose:

The extension automates the process of generating C# classes - interfaces, repositories, services, and controllers from SQL Server database tables, views, and stored procedures within Visual Studio. It is designed to streamline the creation of data access layers and related code for .NET projects.

How the Trial Works

The trial begins the first time you select a table from the Tables dropdown. A dialog prompts you for an email address. After you click Send, a verification email is sent containing a verification code. Enter the code in the verification field below the email address to activate the trial for the currently selected database.

During the trial you can work with the first four tables you select. You may generate unlimited CRUD operations for those four tables within the selected database using the SQL To CSharp Plus tool.

NOTE: The Model Builder is free to use without restrictions even if you opt out on the API Builder.

The Cost

The SQL To CSharp Plus tool is $24.95 USD. The cost is for a single user license and is not tied to a specific machine. You can use it on any machine you own or have access to. The cost is small compared to the time it saves you in creating the code for your data access layer. ROI is typically 10x the cost of the tool. If you use it for a single project it will pay for itself many times over.

Key Features:

• Database Connectivity: Allows users to connect to a SQL Server, browse databases, tables, views, and stored procedures.
• Model Generation: Generates C# model classes based on selected database tables, views, or stored procedure parameters/columns. Supports adding data annotation attributes (e.g., [Required], [StringLength]) for validation.
• Repository Generation: Automates the creation of repository methods for CRUD and custom operations, mapping SQL objects to C# methods.
• Service and Controller Generation: Can generate service and controller classes (including dependency injection and logging support) for use in ASP.NET projects.
• Interface Generation: Produces interfaces for repositories and services to support abstraction and testability.
• Code Customization: Supports custom folder names, class name suffixes, and logging options. Handles both internal and external property/model DLLs.
• Visual Studio Integration: Uses the EnvDTE automation model to manipulate projects, files, and code elements directly within the IDE.
• User Interface: Provides a tool window for selecting projects, configuring options, and triggering code generation.

How It Works:

1. Connect to SQL Server: The user connects to a database and selects tables, views, or stored procedures.
2. Configure Generation Options: The user selects target projects, folders, class names, and code generation options (e.g., attributes, logging).
3. Generate Code: The extension creates C# classes - repository methods, interfaces, services, and controllers based on the selected database objects and user preferences.
4. Insert and Save: Generated code is inserted into the appropriate files and locations in the Visual Studio solution, with all necessary using statements and file headers.

Typical Use Cases:

• Rapidly scaffold data access and API layers for new or existing .NET projects.
• Ensure consistency and reduce manual coding errors when mapping SQL schema to C# code.
• Support for .NET Core/ASP.NET Core projects.

In summary:

Sql To CSharp Plus is a Visual Studio extension that bridges SQL Server and C# by automating the generation of strongly-typed, ready-to-use code for data access and API layers, saving significant development time and effort.

Please let us know if you find the tool helpful and how it's is working for you by leaving a review on the Visual Studio Marketplace.

Thanks,

LoneWorx

Website: http://www.loneworx.com