FC.Extension.SQL 1.0.2

FC.Extension.SQL

✅ Project status: active.

FC.Extension.SQL is a library which adds reduces the coding effort for the development team in terms of handling SQL Basic functionality. You may required literally a single line of code to handle DB Operation.

This library supports

• SQL Server
• PostgreSQL
• MySQL Server
• SQLite

Download

• NuGet: Install-Package FC.Extension.SQL

Features

• Ready to use in the project as an extension
• CRUD for SQL Server, PostgreSQL, MySQL, SQLite
• You can pass Fluent Query to execute any Query
• No Worry about the Language(SQL Server, SQLite/PostgreSQL/MySQL)
• Uses SQLkata to receive as Fluent Query.
• Targets .NET Core 3.1+
• Dependent on RepoDB & SQLkata.

Usage

Quick start

Step 1: Setup the Package

Install-Package FC.Extension.SQL

Step 2:Initial Configuration

using FC.Extension.SQL.Helper;
using FC.Extension.SQL.Engine;
using SqlKata;
..

SQLExtension.SQLConfig = new SQLConfig()
	{
	    Compiler = SQLCompiler.PostgreSQL,
	    ConnectionString = "User Id=FCPos;Password=System@1234;Server=localhost;Port=5432;Database=ExtensionTest;",
	    Trace = null
	};
	
var personFake = new Faker<Person>()
                 .RuleFor(o => o.Name, f => f.Person.FirstName)
                 .RuleFor(o => o.Email, f => f.Person.Email);
var person = personFake.Generate();

Step 3:To Save

person = person.Save().Result;
console.Output.WriteLine($"Saved Object : {person.ToJSON<Person>()}");

Step 4:To Update

person.Id = GetIdEntry();
person = person.Update().Result;
console.Output.WriteLine($"Object Updated : {person.ToJSON<Person>()}");

Step 5:To Delete

person.Id = GetIdEntry();
int records = 	person.Delete(person.Id).Result;
console.Output.WriteLine($"Deleted. No of Records : {records}");

Step 6:To Get Object by Id

person.Id = GetIdEntry();
Person per = person.Get(person.Id).Result;
console.Output.WriteLine($"Received Object : {per.ToJSON()}");

Step 7:To Get Object by Query

int id = GetIdEntry();
var personList = person.GetAny(new Query("Person").Where("Id", id)).Result;

foreach (var model in personList)
{
    console.Output.WriteLine($"Queried Object : {model.ToJSON()}");
}

Step 8:To Get Record Count

var personCount = person.GetCount().Result;
console.Output.WriteLine($"Total Records : {personCount}");

⚠️ All Set. Use the same method for other extension methods. The full featured document available in the Gitbook,

Other Extension

• AWS

  • 

• HTTP

  • 

• RabbitMQ

  • 

• Office

  • 

• SQL

  • 

Complete