Add database for Linq-to-SQL

Question

I am attempting to add a database to a Visual Studio 2010 VB.Net Windows Forms project to interrogate it with Linq-to-SQL. I have added the Linq-to-SQL Entities to the project.

I can connect to the required database with SQL Server Manager using the Server Name, and SQL Server credentials. But using the Add Database feature in Visual Studio requires me to know the database file name, which I don't.

Is there any way to specify the new database using the server name and credentials in Visual Studio 2010, or alternatively to find out what the file name is from SQL Server Manager, or is there a tutorial anywhere I should be following, in case I am doing the whole thing completely wrong?

Mych · Accepted Answer · 2014-04-08 13:51:43Z

2

The file name will be the database name with a mdf extenstion. You can find this out in Management Studio by selecting the db and right click Properties and then click the files tab. last column will have the file name.

answered Apr 8, 2014 at 13:51

Mych

2,5834 gold badges40 silver badges71 bronze badges

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

1 Comment

Brian Hooper Over a year ago

I did wonder why the filename didn't appear on that screen. But I also didn't notice the horizontal scroll bar...

Collectives™ on Stack Overflow

Add database for Linq-to-SQL

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related