Linq to SQL create table

Question

I need to write an WPF(4.0) application which has a DB but no tables in it. The app has to create some tables in the DB and then start working with them. I am wondering , is there a way to do it in Linq to SQL ?

How could Linq create tables?

Andrew Barber
– Andrew Barber

2012-04-09 05:41:49 +00:00
Commented Apr 9, 2012 at 5:41 — Andrew Barber
– Andrew Barber, Commented Apr 9, 2012 at 5:41

Kevin · Accepted Answer · 2019-05-30 20:42:58Z

2

You can do this programatically. i.e. You can create programatically your tables, according to given parameters, also it is possible to build the relations between tables... :)

As there is no direct function create table, you can use the ExecuteCommand -method of the DataContext to run some T-SQL statements for creating tables.

edited May 30, 2019 at 20:42

Kevin

18.8k8 gold badges71 silver badges86 bronze badges

answered Apr 9, 2012 at 5:43

mihai

2,8323 gold badges38 silver badges58 bronze badges

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

3 Comments

N.D Over a year ago

you mean ADO.NET , yes? yeah , I know it's can be generated programatically in ADO.NET but I was hoping that there is an option now to do it by LINQ to SQL...:)

mihai Over a year ago

N.D. To Create a New Table try this exemple: wikihow.com/Use-LINQ-to-SQL-in-C-Sharp#Create_a_New_Table is an exemple of what I suggested you to do in my second part of response

N.D Over a year ago

Thanks , but I have seen that people have some troubles with that , have you tried this solution personally ? I will try it , but I wonder if it really works?

Collectives™ on Stack Overflow

Linq to SQL create table

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related