DBML to SQL script?

Question

Initially I created database tables and generated DBML class file using Database. (LINQ).

But due to system crash, I lost my database instance ( around 20 tables ) and I want to get it back. ( atlest schema )

Is there any tool/ way to generate SQL from DBML file.

Thanks in advance.

teo van kot · Accepted Answer · 2016-05-24 18:08:52Z

2

You can find a way to do it on msdn. I bit citation:

there is enough information about the relational database that you can create a new instance of the database using the DataContext.CreateDatabase method.

YourDbContext db = new YourDbContext ("c:\\yourDbFile.mdf");
db.CreateDatabase();

answered May 24, 2016 at 18:08

teo van kot

12.5k10 gold badges41 silver badges73 bronze badges

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

1 Comment

user3538382 Over a year ago

Thanks for your answer. This helps me.

Uke · Accepted Answer · 2024-04-26 06:53:17Z

0

There is also a Plugin for visual studio code called vscode-dbml that is able to create an sql create script from an dbml file.

answered Apr 26, 2024 at 6:53

Uke

1841 gold badge4 silver badges22 bronze badges

Collectives™ on Stack Overflow

DBML to SQL script?

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related