This project is to write a C# ASP MVC website to allow data to be browsed in a grid given for any DbSet property in an Entity Framework DbContext.
The website should consist of one page containing a drop down list of all data (DbSet properties) defined in a DbContext.
On something being selected from the drop down list, a grid should populate with data from the underlying database table (limited to a certain number of rows as the underlying tables might contain large ammounts of data).
The grid will need to have the ability to have paging, filter each column, sort, and group data. This should apply to the data in the underlying table rather than to the data currently loaded.
For example, imagine a table contains 1 million records. When initially loading we might only return 100 records at first. When someone sets a filter on a column, this should apply on the underlying 1m records and not just on the initial 100 records loaded into the grid. (Though again the number returned would be limited to a certain number - 100 in this case).
The grid should also have the ability to export the data to Excel (as it is currently displayed in the grid, with filters, grouping, sorting applied as is shown in the grid). This should not use the Excel Interop but another library such as OpenXml (or ClosedXml which is a nicer to use wrapper of OpenXml).
The export feature should also give the option to export all data (not just thee limited number of rows displayed in the current grid).
48 freelancers are bidding on average $562 for this job
HI, I can deliver this project within 24-48 hours. I would need to ask a few questions to clarify the scope. Please send me a message if you're interested. Thank you.