title: Generic Data Access Layer
body: <p>I want to build a generic data access layer targeting any multiple databases i.e. SQL Server, Oracle, DB2, etc, and the tricky part is that I need to also support Web Services, so my datasource can also be a Web Service. Each of the data sources have similar data but the column names are different and the return type(s) are different in the web services as well. </p>
  
  <p>How can i create a generic Data access layer to target any datasource and return a generic object/list to the UI in .NET, C#.</p>
  
  <p>.NET 4.5, C#, Web API, VS 2013 is what i am using. </p>
  
  <p>Please suggest. Any help is greatly appreciated.</p>
  
  <p>cheers</p>