什么是 ADO.NET? [英] What is ADO.NET?

问题描述

我已经编写了一些 Access db 并使用了一些轻量级的 VBA，并且有一个 OO 类.现在我正在着手编写一个 C# db 应用程序.我已经安装并连接了 VS 和 System.Data.SQLite，并输入了我的表和列，但这就是我卡住的地方.

I've written a few Access db's and used some light VBA, and had an OO class. Now I'm undertaking to write a C# db app. I've got VS and System.Data.SQLite installed and connected, and have entered my tables and columns, but that's where I'm stuck.

我正在努力寻找我需要查找的信息和教程，但有很多我不理解的术语，我不知道它们是否或究竟如何应用于我的项目.

I'm trying to find what info and tutorials I need to look for, but there are a lot of terms I don't understand and I don't know if or exactly how they apply to my project.

我已经阅读了这些术语的定义(维基百科和其他地方)，但这些定义对我来说没有意义，因为我不知道它们是什么或它们如何组合在一起，或者哪些是可选的或不可选的我的项目.

I've read definitions for these terms (Wikipedia and elsewhere), but the definitions don't make sense to me because I don't know what they are or how they fit together or which ones are optional or not optional for my project.

System.Data.SQLite 网站上的一些术语(我想将 System.Data.SQLite 用于我的数据库).

Some of the terms on the System.Data.SQLite website (I wanted to use System.Data.SQLite for my db).

我认为我的项目的第一步是设置和测试数据库和查询.请告诉我是否还有我需要了解的这部分拼图的其他部分.如果我能弄清楚什么是什么，我就可以开始寻找我需要的教程.(顺便说一句，我知道我不想使用 ORM，因为我的应用程序太简单了，而且我不想过早地过度使用.)

I figured my first step in my project would be to get the db and queries set up and tested. Please tell me if there are other pieces of this part of the puzzle I will need to know about, too. If I can figure out what's what, I can start looking for the tutorials I need. (btw, I know I don't want to use an ORM because my app is so simple, and because I want to keep from biting off too much too soon.)

非常感谢.

SQLite.NET

框架

ADO.NET

ADO.NET 提供程序

ADO.NET provider

SQLite 的 ADO.NET 2.0 提供程序

ADO.NET 2.0 Provider for SQLite

更新: 删除了实体框架"术语，因为它们显然是 ORM，我不会使用.

Update: Removed "Entity Framework" terms because apparently they are ORM's, which I won't be using.

另外，请告诉我，就好像我一无所知，除了我有限的经验(以上)涵盖的内容(不幸的是，情况就是这样，因为我在尝试研究这些东西时变得如此困惑，所有这些条款让我不堪重负.)谢谢.

Also, please talk to me as if I know nothing except what my limited experience (above) covers (unfortunately that's the case since I've gotten so confused while trying to research this stuff, all the terms have overwhelmed me into overload-paralysis.) Thank you.

推荐答案

松散，简单说

ADO.NET是一个命令和对象库，允许您的应用程序与数据库对话.如果您在 VB6/C++ 中使用过 ADODB，那么 ADO.NET 是 .net (vb.net/C#) 等价物.ADO.NET 为您提供了诸如连接对象、数据集和数据读取器对象之类的对象.

ADO.NET is a library of commands and objects that allow your application to talk to a database. If you have used ADODB in VB6/C++ then ADO.NET is the .net (vb.net/C#) equivalent. ADO.NET provides you with objects such as a connection object, dataset and datareader objects.

ADO.NET 提供程序将提供程序视为图形或设备驱动程序.每次将不同的显卡放入计算机时，您都需要有一个新的显卡驱动程序才能使显卡发挥最佳性能.ADO.NET 也是如此，对于您连接到的每种不同类型的数据库(例如 Microsoft Access、Microsoft SQL Server、MySQL、Sybase、Oracle 等)，您将需要不同的 ADODB.Net 提供程序.少数是标准配置(例如，SQL Server 的提供程序)

ADO.NET provider Think of a provider like a graphics or device driver. Each time you put a different graphics card inside your computer you need to have a new graphics driver to get your graphics card to work at its best. The same is true for ADO.NET, for each different type of database you connect to (e.g Microsoft Access, Microsoft SQL Server, MySQL, Sybase, Oracle etc.) you will need a different ADODB.Net provider. A handful come as standard (for example, the provider for SQL Server)

SQLite.NET是数据库服务器还是 RDBMS - 将其视为 SQL Server 或 MySQL 的轻量级竞争对手.

SQLite.NET Is a database server or RDBMS - think of it as a lightweight competitor to SQL Server or MySQL.

SQLite 的 ADO.NET 2.0 提供程序结合最后两个答案！

SQLite 实体框架和 SQLite 实体框架提供程序这是一个完全不同的主题.查找对象关系映射

SQLite Entity Framework and SQLite Entity Framework provider This is a whole different subject completely. Look up Object Relational Mapping

这篇关于什么是 ADO.NET?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！