简介数据库的交互用C#

问题描述:

到现在为止在我的编程生涯(2年),我没有太多的数据库经验,但该公司在那里我现在的工作使用广泛的数据库为他们的产品,我觉得落后。

Up to now in my programming career (two years) I have not had much database experience, but the company where I now work uses databases extensively for their product, and I feel behind the curve.

所以,我想知道如何最好地开始学习数据库的交互使用C#。我读过有关LINQ到SQL和ADO.net。这些是正确的技术来看看?

So I would like to know how best to start learning database interaction with C#. I've read about LINQ-to-SQL and ADO.net. Are these the right technologies to look into?

我从哪里开始?

编辑:感谢所有的答复。我有一个很难选择一个作为的的答案 - 有许多好的。这有助于我极大!

Thanks for all the responses. There were many good ones - I had a hard time choosing one as "the" answer. This helps me greatly!

我会建议投资你的时间在学习 Microsoft SQL Server的本身,数据访问应用程序块从企业库和 ADO.NET实体框架

I would suggest investing your time in learning Microsoft SQL Server itself, Data Access Application Block from Enterprise Library and ADO.NET Entity Framework.

切入点来学习SQL Server是在这里 - > SQL Server开发人员中心
切入点学习ADO.NET是在这里 - > 学习ADO.NET 在MSDN

Entry point for learning SQL Server is here -> SQL Server Developer Center
Entry point for learning ADO.NET is here -> Learning ADO.NET at MSDN

首先,为了获得什么ADO.NET是一个很好的了解,请点击下面的链接:

First of all, in order to gain a good understanding of what ADO.NET is, check the links below:

  • ADO.NET at Wikipedia
  • ADO.NET Entity Framework at Wikipedia

了解如何编写在C#中的SQL Server直接查询,而无需使用任何框架和ORM工具,然后继续在ADO.NET家庭学习更先进的技术。

Learn how to write direct queries in C# to SQL Server without using any frameworks and ORM tools, then proceed to learning more advanced technologies in ADO.NET family.

另请参见

  • Data Access Application Block at MSDN
  • The ADO.NET Entity Framework Overview at MSDN
  • Learn ADO.NET Entity Framework ("How Do I" videos and more)
  • Videos, Screencasts, Tutorials at ASP.NET
  • Microsoft SQL Server 2008: ADO.NET Entity Framework

您可能还需要下载的 LINQPad ,这是玩完美的工具使用LINQ。

You may also want to download LINQPad, which is perfect tool for playing with LINQ.

此外,我建议订阅ADO.NET相关的 RSS源

Also I suggest subscribing to ADO.NET related RSS feeds:

  • ADO.NET Team Blog at MSDN

另外,请检查现有的 codePlex.com 其中使用这些技术和Digg的开源项目到他们的源$ C ​​$ CS。

Also check existing open source projects at CodePlex.com which use these technologies and digg into their source codes.

名著对你这个问题:

  • Microsoft SQL Server 2008 T-SQL Fundamentals by Itzik Ben-gan (Oct, 2008)
  • Programming Entity Framework by Julia Lerman (Feb, 2009)
  • Murach's ADO.NET 3.5, LINQ, and the Entity Framework by Anne Boehm (Mar, 2009)