I am trying to write a Windows Form and ASP.NET C# front-end and MSAccess backend for a pretty small database concept I have.
我正在尝试编写一个Windows窗体和ASP.NET C#前端和MSAccess后端,以获得我所拥有的非常小的数据库概念。
I have written this application once before in just MSAccess but I now need the app and database to be in different places. I have now figured out (thanks to a * user) that ADO will be a bad choice because it has to have a connection open all of the time.
我之前曾在MSAccess中编写过这个应用程序,但我现在需要将应用程序和数据库放在不同的地方。我现在想通了(感谢*用户)ADO将是一个糟糕的选择,因为它必须始终打开一个连接。
I bought Microsoft ADO.Net 2.0 Step-by-Step and I have read through some of it and understand (I think) the basic concepts at play in ADO.NET. (Datasets and the like)
我逐步购买了Microsoft ADO.Net 2.0,我已经阅读了一些并理解(我认为)ADO.NET中的基本概念。 (数据集等)
Where I get confused is the actual implementation. What I want to know is do any of you know of a C# project that has a database backend which is open source that I can go look at the code and see how they did it. I find I learn better that way. The book has a CD with code examples that I may turn to, but I would rather see real code in a real app.
我感到困惑的是实际的实施。我想知道的是你们有没有人知道一个C#项目,它有一个开源的数据库后端,我可以去查看代码并看看他们是如何做到的。我发现我的学习方式更好。这本书有一张代码示例的CD,我可以转向,但我宁愿在真正的应用程序中看到真正的代码。
4 个解决方案
#1
0
I haven't used this but it looks like it might be a good fit:
我没有使用它,但看起来它可能是一个很好的选择:
http://www.codeproject.com/KB/database/DBaseFactGenerics.aspx
#2
0
Take a look at the MySQL .net connector. It is the nuts and bolts of how the ADO.net classes talk to the DB engine. ADO.net as a whole does not keep connections open. Certain higher level classes do. Technically the lower level objects such as the connection and command objects are part of ADO.net, but you have a high degree of control over them.
看看MySQL .net连接器。它是ADO.net类如何与数据库引擎通信的基本要点。 ADO.net作为一个整体并不保持连接开放。某些更高级别的课程。从技术上讲,较低级别的对象(如连接和命令对象)是ADO.net的一部分,但您可以对它们进行高度控制。
#3
0
Check CodePlex, they have a ton of .NET projects. I can't think of specific ones that fit your requirements, but you should be able to find something.
检查CodePlex,他们有大量的.NET项目。我无法想到符合您要求的具体产品,但您应该能够找到一些东西。
www.codeplex.com
#4
0
I found this post http://www.codeproject.com/KB/database/DatabaseAcessWithAdoNet1.aspx by searching for ADO.NET on the codeproject so I am going to give Chris Porter the answer points. Thanks everyone for the help.
我通过在代码项目中搜索ADO.NET找到了这篇文章http://www.codeproject.com/KB/database/DatabaseAcessWithAdoNet1.aspx,所以我将给Chris Porter一个答案。谢谢大家的帮助。
#1
0
I haven't used this but it looks like it might be a good fit:
我没有使用它,但看起来它可能是一个很好的选择:
http://www.codeproject.com/KB/database/DBaseFactGenerics.aspx
#2
0
Take a look at the MySQL .net connector. It is the nuts and bolts of how the ADO.net classes talk to the DB engine. ADO.net as a whole does not keep connections open. Certain higher level classes do. Technically the lower level objects such as the connection and command objects are part of ADO.net, but you have a high degree of control over them.
看看MySQL .net连接器。它是ADO.net类如何与数据库引擎通信的基本要点。 ADO.net作为一个整体并不保持连接开放。某些更高级别的课程。从技术上讲,较低级别的对象(如连接和命令对象)是ADO.net的一部分,但您可以对它们进行高度控制。
#3
0
Check CodePlex, they have a ton of .NET projects. I can't think of specific ones that fit your requirements, but you should be able to find something.
检查CodePlex,他们有大量的.NET项目。我无法想到符合您要求的具体产品,但您应该能够找到一些东西。
www.codeplex.com
#4
0
I found this post http://www.codeproject.com/KB/database/DatabaseAcessWithAdoNet1.aspx by searching for ADO.NET on the codeproject so I am going to give Chris Porter the answer points. Thanks everyone for the help.
我通过在代码项目中搜索ADO.NET找到了这篇文章http://www.codeproject.com/KB/database/DatabaseAcessWithAdoNet1.aspx,所以我将给Chris Porter一个答案。谢谢大家的帮助。