I am new to creating interfaces and was wondering if anyone knows of good tutorials/Examples of how to create them. I code mainly ASP.NET, C# and T-SQL. Thanks.
-
2Could you please clarify the notion of a database interface?Darin Dimitrov– Darin Dimitrov2011-02-10 19:14:45 +00:00Commented Feb 10, 2011 at 19:14
-
Could you be more specific? What are you trying to do?Andrew– Andrew2011-02-10 19:15:01 +00:00Commented Feb 10, 2011 at 19:15
-
What exactly are you asking? How to write a data access layer? This question seems way too broad.Adam Robinson– Adam Robinson2011-02-10 19:15:21 +00:00Commented Feb 10, 2011 at 19:15
-
I think what you're looking for is an ORM, take a look at Linq to SQLGuillaume86– Guillaume862011-02-10 19:19:46 +00:00Commented Feb 10, 2011 at 19:19
4 Answers
I wrote a fairly sophisticated three-tier app in VB after reading one of the Murach books. There's one for C# and ASP.NET on VS 2008.
Comments
The concepts outlined in this tutorial helped me a lot a few years ago - it's quite detailed but might be quite out of date now (SQL Server 2005)
http://www.asp.net/data-access/tutorials/creating-a-data-access-layer-cs
But it's directly aimed at C# ASP.NET, so should be suited to you I think.
Comments
You might want to consider using an existing ORM mapper instead of building your own data access layer from scratch as a lot of it is boiler plate code any way. A popular one in the .NET community is NHibernate