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...

Does this answer your question? How can I generate database tables from C# classes? — Mehdi Dehghani
– Mehdi Dehghani, Commented Feb 11, 2020 at 17:54

JotaBe · Accepted Answer · 2012-05-03 14:10:55Z

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 3, 2012 at 14:10

JotaBe

39.3k9 gold badges102 silver badges121 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Icarus · Accepted Answer · 2012-05-03 14:10:53Z

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 3, 2012 at 14:10

Icarus

64k14 gold badges102 silver badges116 bronze badges

Comments

Peposh · Accepted Answer · 2012-05-03 14:50:27Z

0

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.

answered May 3, 2012 at 14:50

Peposh

1827 bronze badges

Collectives™ on Stack Overflow

Create SQL Server database tables from C# classes

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related