DapperGenericDataManager 1.0.0

Simple Generic Data manager with Basic CRUD methods using Dapper and Dapper.Contrib.Extensions. GitHub Repo: https://github.com/raniel12345/DapperGenericDataManager

Usage:

public class StudentsData : DataManagerCRUD<Student>, IStudentsData
    {

        private readonly IDbConnectionFactory _dbConnectionFactory;

        public StudentsData([Dependency("Main")] IDbConnectionFactory dbConnectionFactory)
            : base(DataManagerCRUDEnums.DatabaseAdapter.mysqlconnection, dbConnectionFactory)
        {
            _dbConnectionFactory = dbConnectionFactory;
        }

        public Student GetByStdNum(string stdNum)
        {
            string query = "SELECT * FROM Students WHERE stdNum=@StdNum";
            return this.GetFirstOrDefault(query, new
            {
                StdNum = stdNum
            });
        }
}

Class Methods:

public List<AreaDept> GetAllActive ()
{
    string query = "SELECT * FROM Employees WHERE isDeleted=false";
    return this.GetAll(query);
}


public bool CancelAll (long plsId)
{
	string query = "UPDATE PLSDetails SET isCancelled=true, deviceCostCollectorRemarks='Cancelled' WHERE PLSId=@PLSId AND id > 0";

	int rowsAffected = 0;
	using (var conn = _dbConnectionFactory.CreateConnection())
	{
		rowsAffected = conn.Execute(query, new
		{
			PLSId = plsId
		});
		conn.Close();
	}

	return rowsAffected > 0;
}

You can use any dependency injection library out there, for the example in git repo. I use Unity.mvc5

I will provide more example in git repo for the coming days.