1.At the logic level you could use the data access services provided by the next technologies: ADO.NET, Entity Framework or NHibernate.
2.On top of these services you could use LINQ
3.At the user interface level you could use 4 types of applications:
a)Windows Forms - and to use the existing forms controls like
DataGridView[
^]
b)WPF (windows Presentation Foundation) and the MVVM pattern, and the similar control for grid:
GridView[
^]
c)ASP.NET web application and the
GridView web control[
^] I have also an article about using this topic:
Advanced ASPX GridView Pagination and Data Entities[
^]
d)ASP.NET MVC web application and here you could use
jqGrid
like I did in my next article:
MVC Basic Site: Step 4 – jqGrid Integration in MVC 4.0 using AJAX, JSON, jQuery, LINQ, and Serialization[
^]
4. Note that WCF is for communication between applications and/or applications layers.