SqlBuilder_QueryInCode 1.0.0

SqlBuilder

Query In Code

SQL Query Builder for .NET: Unlocking SQL Power, The SQL Query Builder is a straightforward framework that empowers .NET developers to craft SQL-like queries, directly interacting with SQL Server datastores.

• Write familiar SQL syntax within your .NET code.
• Optimize queries for performance and efficiency, tapping into SQL Server's native strengths.
• Maintain database control, utilizing advanced SQL features.

Prerequisites

• Compatible with a wide range of .NET versions
• Supports .NET Framework 4.6.1 and later, .NET Core, and .NET 5/6/7/8
• Suits, both the older .NET Framework projects and newer .NET Core/NET projects
• Any ORM that supports Parameterized SQL Queries, Dapper.Net is ideal and recommended

Getting started

• Using the .NET CLI, open a command line and navigate to the directory containing your project file, and Use the command dotnet add package SqlBuilder to install the package.
• Using Visual Studio, Go to Tools > NuGet Package Manager > Package Manager Console, under Browse search for SqlBuilder, select the latest version and install.

Usage

Below are the requirements to run the following sample code.

• Access to northwind database.
• Appropriate connection to northwind database
• Create a console application [say, DemoApplication with .NET 8 Core]
• Install Microsoft.Data.SqlClient package in the console application
• Install Dapper package in the console application
• Install SqlBuilder package in the console application

using Dapper;
using Microsoft.Data.SqlClient;
using SqlBuilder;

namespace DemoApplication
{
    internal class Program
    {
        static string ConnectionString = "{${northwind database connection string}}";
        static void Main(string[] args)
        {
            var (sql, parameters) = new SqlQueryBuilder()
                .Select().Columns("CustomerID", "CompanyName")
                .Column("ContactName", "Name")
                .Column("ContactTitle", "Title")
                .From("Customers")
                .Where(new Where(new IN(new Column("CustomerID"), "ALFKI", "ANATR", "BERGS", "BOTTM", "CHOPS", "FRANK", "GODOS")))
                .Build();
            List<CustomCustomers> customCustomers = new List<CustomCustomers>();
            using (var connection = new SqlConnection(ConnectionString))
            {
                customCustomers = connection.Query<CustomCustomers>(sql, parameters).ToList();
            }            
            Console.WriteLine("Parameters Used:");
            parameters.Keys.ToList().ForEach(k => 
            {
                Console.WriteLine($"Key: {k}, Value: {parameters[k]}");
            });            
            Console.WriteLine();
            Console.WriteLine("Query Output:");
            customCustomers.ForEach(k => Console.WriteLine(k.ToString()));
            Console.ReadKey();
        }
    }

    public class CustomCustomers
    {
        public string CustomerID { get; set; }
        public string CompanyName { get; set; }
        public string Name { get; set; }
        public string Title { get; set; }

        public override string ToString()
        {
            base.ToString();
            return $"CustomerID: {CustomerID}, CompanyName: {CompanyName}, Name: {Name}, Title: {Title}.";
        }
    }
}

Additional documentation

Get various examples to use the SqlBuilder, follow the link https://www.thebluesoft.co.in/SqlBuilder

Feedback

Help us improve! Share your feedback, your feedback helps us to make SqlBuilder more useful and user friendly, share your thoughts on: https://www.thebluesoft.co.in/#section_5