This is the component, works on .NET Core and.NET Framework

varconnection=newConnection(){Database=RepositoryHelpers.Utils.DataBaseType.SqlServer,//RepositoryHelpers.Utils.DataBaseType.OracleConnectionString="Your string"};

varRepository=newCustomRepository<User>(conecction);

[DapperIgnore]// Property will be ignored in select, insert and updatepublicstringInternalControl{get;set;}[PrimaryKey]// Primary keypublicintMyCustomId{get;set;}[PrimaryKey][Identity]//Indicates that the primary key has some identity, sequence or auto incrementpublicintMyBdIdIndentity{get;set;}//You can optionally map the name of the Database table that refers to the entity[Table("Product")]publicclassProducts{publicintId{get;set;}}

publicclassProductMap:DommelEntityMap<Product>{publicProductMap(){Map(p=>p.Id).IsKey().IsIdentity();Map(p=>p.Category).Ignore();}}

publicclassProductMap:DommelEntityMap<Product>{publicProductMap(){ToTable("Product");Map(p=>p.Id).IsKey().IsIdentity();Map(p=>p.Category).Ignore();}}

Mapper.Initialize(c=>{c.AddMap(newProductMap());});

//Get All UsersvarusersAsync=awaitRepository.GetAsync();varusers=Repository.Get();//Get User by IdvaruserAsync=awaitRepository.GetByIdAsync(1);varuser=Repository.GetById(1);//Get by CustomQuery with parametersvarcustomQuery="Select name from user where login = @userLogin";varparameters=newDictionary<string,object>{{"userLogin","bertuzzi"}};varresultASync=awaitRepository.GetAsync(customQuery,parameters);varresult=Repository.Get(customQuery,parameters);//Get by CustomQuery without parametersvarcustomQuery="Select * from user";varresultASync=awaitRepository.GetAsync(customQuery);varresult=Repository.Get(customQuery);//Get by multi-mapping custom query with 2 input typesvarcustomQuery="Select * from user inner join category on user.categoryId = category.Id where login = @userLogin";varuser=Repository.Get<User,Category,User>(customQuery,map:(user,category)=>{user.Category=category;returnuser;});//Get by multi-mapping custom query with 2 input types (When the field that we should split and read the second object is different from "Id")varcustomQuery="Select * from user inner join state on user.stateCode = state.Code where login = @userLogin";varuser=Repository.Get<User,State,User>(customQuery,map:(user,state)=>{user.State=state;returnuser;},parameters,splitOn:"Code");//Get by multi-mapping custom query with an arbitrary number of input typesvarcustomQuery="Select * from user inner join category on user.categoryId = category.Id where login = @userLogin";varuser=Repository.Get(customQuery,new[]{typeof(User),typeof(Category)},map:(types)=>{varuser=(types[0]asUser);user.Category=(types[1]asCategory);returnuser;});

Repository.Insert(NewUser,true);

Repository.Update(updateUser);Repository.UpdateAsync(updateUser);

Repository.Delete(1);Repository.DeleteAsync(1);

//Return DataSetvarcustomQuery="Select name from user where login = @userLogin";varparameters=newDictionary<string,object>{{"userLogin","bertuzzi"}};Repository.GetDataSet(customQuery,parameters);//ExecuteQueryRepository.ExecuteQueryAsync();Repository.ExecuteQuery();//ExecuteScalarRepository.ExecuteScalarAsync();Repository.ExecuteScalar();//ExecuteProcedureRepository.ExecuteProcedureAsync();Repository.ExecuteProcedure();

CustomTransactioncustomTransaction=newCustomTransaction(YourConnection);customTransaction.BeginTransaction();customTransaction.CommitTransaction();customTransaction.RollbackTransaction();//SampleRepository.ExecuteQuery("yourquery",parameters,customTransaction);

publicsealedclassConnectionHelper{staticConnectionHelper_instance;publicstaticConnectionHelperInstance{get{return_instance??(_instance=newConnectionHelper());}}privateConnectionHelper(){Connection=newConnection(){Database=RepositoryHelpers.Utils.DataBaseType.SqlServer,ConnectionString="YourString"};}publicConnectionConnection{get;}}publicclassBaseRepository<T>{protectedreadonlyCustomRepository<T>Repository;protectedBaseRepository(){Repository=newCustomRepository<T>(ConnectionHelper.Instance.Connection);}}publicclassBaseTransaction:CustomTransaction{publicBaseTransaction():base(ConnectionHelper.Instance.Connection){}}