Mapping database to entity

gistfile1.cs

        public override IQueryable<TEntity> GetAll()
        {
            var table = base.Context.ExecutarSQL(Querys[QueryType.GetAll], null);

            var i = table.Rows.Cast<object>().Select(row =>
            {
                var entity = new TEntity();

                foreach (var prop in entity.GetType().GetProperties())
                {
                    var property = entity.GetType().GetProperty(prop.Name, BindingFlags.Public | BindingFlags.Instance);

                    if (null != property && property.CanWrite)
                    {
                        property.SetValue(entity, ((DataRow)row)[prop.Name], null);
                    }
                }

                return entity;
            });

            return i.AsQueryable();
        }