Create SQL Server database tables from C# classes

Question

Is it possible to automatically convert a lot of C# classes to SQL Server database tables ?

I need to import some xml files into SQL Server but using SSIS the runtime stops working as soon as I select the xsd file. However I easily converted the xsd to class files so that's why I am asking if its possible to have a workaround...

http://stackoverflow.com/questions/47239/how-can-i-generate-database-tables-from-c-sharp-classes — Habib, May 03 '12 at 14:10
Does this answer your question? [How can I generate database tables from C# classes?](https://stackoverflow.com/questions/47239/how-can-i-generate-database-tables-from-c-sharp-classes) — Mehdi Dehghani, Feb 11 '20 at 17:54

score 5 · Answer 1 · answered May 03 '12 at 14:10

5

You can use Entity Framework Code First functionality, with a little extra work to get the tables done in your database.

There you have a good post on it by ScottGu

answered May 03 '12 at 14:10

JotaBe

38,030
8
98
117

score 3 · Answer 2 · answered May 03 '12 at 14:10

3

Yes, it's possible to automatically do this. Entity Framework has a model called Code First, which essentially does this: takes your C# classes and creates the database and tables automatically for you.

Take a look at this post by Scott Guthrie.

answered May 03 '12 at 14:10

Icarus

63,293
14
100
115

score 0 · Answer 3 · answered May 03 '12 at 14:50

Other option you might test is DataSet.ReadXml() function. Drawback is the Dataset can't handle complexType="mixed", but it deals well with large files (my files had about 50M each). All tables and columns are named by XML tags and relations are autogenerated by DataSet itself.

Create SQL Server database tables from C# classes

3 Answers3