简介数据库的交互用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 在Wikipedia
- ADO.NET实体框架在Wikipedia
- 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.
另请参见
- 数据访问应用程序块的MSDN上
- ADO.NET实体框架概述在MSDN 李>
- 了解ADO.NET实体框架(我怎么视频等等)
- 视频,截屏,的教程在ASP.NET
- 的Microsoft SQL Server 2008:ADO.NET实体框架
- 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团队博客在MSDN
- 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基础由伊茨克奔淦(十月的, 2008)
- 编程实体框架通过朱莉娅勒曼(2009年2月)
- Murach的ADO.NET 3.5,LINQ和实体框架通过安妮·伯姆( 2009年3月)
- 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)