Dazzling.Studio.SqlRepository by Dazzling Studio B.V.

<PackageReference Include="Dazzling.Studio.SqlRepository" Version="1.0.1" />

 BaseRepository<TEntity>

public abstract class BaseRepository<TEntity> : IBaseRepository<TEntity> where TEntity : IDazzlingEntity
protected static object _syncLock

protected string _connectionStringName

protected string _tableName

protected string _tableSchema

public string TableName { get; }

public string TableSchema { get; }

protected BaseRepository()

protected BaseRepository(string tableName)

protected BaseRepository(string connectionStringName, string tableSchema, string tableName = null)

public static BaseRepository<TEntity> Instance<R>() where R : BaseRepository<TEntity>

public virtual IEnumerable<TEntity> All<TType>(TType[] ids)

public virtual IEnumerable<TEntity> All(string where = null, string orderBy = null, int top = 0, object parms = null)

public virtual long Count(string where = null, object parms = null)

public virtual void Delete(TEntity entity)

public virtual void DeleteById<Y>(Y id)

public virtual Y Insert<Y>(TEntity entity)

public virtual IEnumerable<TEntity> Paged(out int totalRows, string where = null, string orderBy = null, int page = 0, int pageSize = 20, object parms = null)

protected void SetConnection(SqlConnection connection)

public virtual TEntity Single<IID>(IID id)

public virtual TEntity Single(string where = null, object parms = null)

public virtual void Update(TEntity entity)