English 中文(简体)
通用数据库处理员班,以便于查阅C#中的所有公众数据库
原标题:Generic Database Handler class to ease access to all popular databases in C#
  • 时间:2011-01-29 03:19:12
  •  标签:
  • c#
  • database

我需要一个小组来方便地处理所有数据库。 例如,使用ado和ql,我们有SqlConnection,但不是通用的,对于另一个数据库类型,你必须使用其他类别。

我希望数据库Connection类型的物体能够轻易地让我与各类数据库连接,让我就数据库提出询问。

最佳回答

OleDB can work. But this has a performance hit.

而是与“IDb”接口。 我认为,它们属于名称空间系统。 数据。 利用这些接口使两个世界都处于最佳地位。 你的代码是独立的数据库,但仍有数据库特定数据提供人的业绩。 Idb接口还使OleDB能够在必要时使用。 实际用户将配置在您的网页上。

ALWAYS(总是)使用IDb接口。

目标导向方案101。 连接方案,而不是执行。

问题回答

OleDbConnection in the System.Data.OleDb namesapce

我建议你使用一个数据存取目标模式的抽象工厂。 这应符合你们的需要。 见。 全面研究模式。 虽然网站用java语说话,但模型也可在c#中使用。





相关问题
Anyone feel like passing it forward?

I m the only developer in my company, and am getting along well as an autodidact, but I know I m missing out on the education one gets from working with and having code reviewed by more senior devs. ...

NSArray s, Primitive types and Boxing Oh My!

I m pretty new to the Objective-C world and I have a long history with .net/C# so naturally I m inclined to use my C# wits. Now here s the question: I feel really inclined to create some type of ...

C# Marshal / Pinvoke CBitmap?

I cannot figure out how to marshal a C++ CBitmap to a C# Bitmap or Image class. My import looks like this: [DllImport(@"test.dll", CharSet = CharSet.Unicode)] public static extern IntPtr ...

How to Use Ghostscript DLL to convert PDF to PDF/A

How to user GhostScript DLL to convert PDF to PDF/A. I know I kind of have to call the exported function of gsdll32.dll whose name is gsapi_init_with_args, but how do i pass the right arguments? BTW, ...

Linqy no matchy

Maybe it s something I m doing wrong. I m just learning Linq because I m bored. And so far so good. I made a little program and it basically just outputs all matches (foreach) into a label control. ...

热门标签