🖌️
FC.Extension
  • FC.Extension
  • How to Use?
  • Release Note
  • FC.Extension.List
    • ToDataTable
  • FC.Extension.Date
    • Age
  • FC.Extension.String
    • Encrypt
    • Decrypt
    • Truncate a String
  • SQL
    • SQL Extension
    • PostgreSQL Extension
Powered by GitBook
On this page
  • Introduction
  • A Main Method which invokes all the command

Was this helpful?

  1. SQL

SQL Extension

An extension of SQL Style of Database, SQL Server, PostgreSQL, SQLite & MySQL

Introduction

This Extension library uses the RepoDB as a primary Database Access, on top this an extension method has been added to avoid repeated code, which is easy for development team to focus on the core operation.

Install-Package FC.Extension.SQL

The above will install the latest package from the nuget.

Through out this Data Access Example I have used a model called "Person" below is the full code for the class Person.

public class Person
{
    public int Id { get; set; }
    public string Name { get; set; }
    public string Email { get; set; }   
}

A Main Method which invokes all the command

public static class Program
{
    public static async Task<int> Main() =>
        await new CliApplicationBuilder()
            .AddCommandsFromThisAssembly()
            .Build()
            .RunAsync();
}

All source code can be found in Github Repository

PreviousTruncate a StringNextPostgreSQL Extension

Last updated 3 years ago

Was this helpful?