- This is Helpful For Do Crud Operation Automaticlly
- Give A Like To This Repo If you Found Something Helpful
- ✨RNG✨
Tables of contents
- KeplerCrud Is Just A Tool For Generic CRUD(Create Read Update Delete) Using This You Can Save Your Time Creating Duplicate Queries And Services
- This Is light Wieght and Easy To Use Package
- .net 3.1 or newest
- Table In Database and Connected with Sql Server
- IDbConnection Object
CREATE TABLE [dbo].[Person](
[Id] [int] IDENTITY(1,1) NOT NULL,
[Name] [varchar](100) NOT NULL,
CONSTRAINT [PK_Person] PRIMARY KEY CLUSTERED
(
[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
- Go On Nuget Install This Package or Using Command Line
$ dotnet add package Rng.KeplerCrud --version 3.2.1- Then Just Add Connection String In Your AppSettings.json Ex is Given Below
{
"Logging": {
"LogLevel": {
"Default": "Information",
"Microsoft.AspNetCore": "Warning"
}
},
"ConnectionStrings": {
"Value": "Server=localhost;Database=DatabaseName; User ID=username;Password=password;"
},
"AllowedHosts": "*"
}- Then Add Attributes in Model
//Don't Forget To Include KeplerCrud.Utility Namespace
using KeplerCrud.Utility;
namespace RNG.Models
{
[KeplerTable("User")] // This Attribute Tells That Table Name Is User
public class User
{
[KeplerPKey("Id")] // This Attribute Tells That This Property Is Primary Key Of User Table
[KeplerColumn("Id")] // This Attribute Tells That This Property Is For Id Column Of User Table
public int Id { get; set; }
[KeplerColumn] // This Attribute Takes Property Name As Column Of User Table
public string Name { get; set; }
// If You Don't Use KeplerColumn Attribute and put colunmBase Fetch, Insert or Update Then You Won't Get This Column Value Or You Can't Save This
}
}- And Where You Want To Call Db To Perform Crud Just Use Like This
//namespace for KeplerRepository
using KeplerCrud.Repostiory
//You Have To Create A Object of IDbConnection First Like This With Your Connection String
using IDbConnection con = _connectionBuilder.connectionProp;
//then Just Call methods And Perform CRUD
var listOfObject = con.GetAll(true);
//Thats It Thats It
- Q1 Why we You need this
- Ans. This Is Light Weight and Fast To Perform CRUD And Using This you Don't need to write Much Code
- Q2 What is columnBase Bool Parameter
- Ans. If You Pass True in that then it will Only Use those Columns Where you have used KeplerColumn Attribute And Other Columns Will Be Ignored
- Q3 What is List of ConditionPair or condition
- Ans. If you create a object like below and pass this object then it will filter out whatever condition you put
var conditions = new List<ConditionPair>(); conditions.Add(new ConditionPair{ Where = "Id",Operator = "=", Value = "2"};
/* use IdbConnection Object Before Using Methods Use Attributes In that models */
/* =============== GetAll(List<ConditionPair> conditions, bool columnBase) ================*/
con.GetAll<Model>( List<ConditionPair> conditions, bool columnBase)
//This Method Will Return All Records Based On Condtions
/* =============== GetAll<T>(bool columnBase) ================
con.GetAll<Model>( bool columnBase)
//This Method Will Return All Records
/* =============== Get<T>(List<ConditionPair> conditions, bool columnBase ) ================*/
con.Get<Model>(List<ConditionPair> conditions, bool columnBase )
//This Method Will Return Record Based On Condtions
/* =============== Insert<T>(T model) ================*/
con.Insert<Model>(T model)
//This Method Will Insert The Record
/* =============== Update<T>(T model) ================*/
con.Update<Model>(T model)
//This Method Will Update The Record
/* =============== Delete<T>(string pvalue) ================*/
con.Delete<Model>(string pvalue)
//This Method Will Delete RecordThanks❤ Myself Raj Narayan Gupta- I would Like To collaborate With Other Developers💛
- Mail : [email protected]
- Follow Us On Instagram
MIT
