Is there anything like Code Igniter's DBForge for C#?

Question

The Database Forge Class contains functions that help you manage your database.

It can:

• Create or drop a database
• Add fields and keys
• Create, drop and modify a table

I was wondering if anything like that existed for C# or .Net.

Otherwise, I think I have a little project on my hands.

Answer 1

Microsoft ADO Ext. implements that functionality... see Create Database Using C#, but it is a COM component may be managed one will be valuable

Answer 2

Maybe you can help the library to work with DataBases from CodeProject: Database Utilities for C#

Answer 3

I just found the perfect thing. The only minor drawback is that it is limited to Microsoft SQL Server.

The thing is called SQL Server Management Objects and here are two good tutorials:

• How to create tables
• How to create stored procedures