How to connect to SQL Server Express DB from Server Explorer VS 2010?
I'm trying to connect to SQL DB from Server Explorer to generate context classes for Linq to SQL. Doing it like described here: http://visualcsharptutorials.com/ado-net/querying-database-linq-to-sql/
I'm getting "This file is in use." error when I try to connect. Even if I stop SQL Server in Configuration Manager I get the same error.
I can connect to DB using SSMS at the same time.
What am I doing wrong? Is it possible to connect to a DB simultaneously from VS and SSMS?
Thanks
When you say I can connect to DB using SSMS at the same time this sounds to me as if you've attached the database to SQL Server Express, and you're talking to it through its logical database name.
When you have done this (which is the best approach, in my opinion), then SQL Server (Express) is using that file and controls all access to it; you cannot just reference the .mdf file from your VS solution - you need to use the SQL Server approach and connect to the SQL Server (Express) instance and pick the database:
Select
Microsoft SQL Server (SqlClient)from theData Sourcedropdown (NOT something like "database file")- the server name and instance you want to use (typically:
.\SQLExpress- the SQLExpress instance on your local machine) the database from the
Select or enter a database namedropdownDO NOT use anything that has to do with "attach database file" or anything like that
- How to use FakeItEasy to fake a complex linq query parsing to dictionary
- A dictionary where value is an anonymous type in C#
- Filtering a List with other two Lists
- Convert string to int for ordering using LINQ
- Linq aggregating on subgroups
- Azure CosmosDB: Read exactly one document via Microsoft.Azure.DocumentDb API
- Create LINQ Query With Multiple Filters on a Single Column And Multiple Columns with Filters
- LINQ: Why does a union of a union throw error message "IQueryable<...> does not contain a definition for 'Union'"?
- Read only first item from IAsyncEnumerable, then cancel
- Union with EF Core returns unable to translate set operation since both operands have different 'Include' operations
- MongoDB Convert aggregate query in node.js to LINQ
- How can I get access to the object corresponding to the key, when using `GroupBy` in LINQ?
- Linq group by performance
- Value object with linq cannot do contains method
- WPF Linq Any query on TreeViewItem tag cast question
- Get DescriptionAttribute via reflection
- Find() and First() throws exceptions, how to return null instead?
- How to project from `Dictionary<A, B>` to `Dictionary<A,C>` with AutoMapper?
- Entity Framework Core : Include not working for many-to-many relationship
- Linq custom comparer for contains?
- c# Linq, how return query with ENUM
- Sending data with viewbag
- How to generate a lambda expression from this T-SQL code
- MVC4 linq query to object doesn't come out as the correct object
- LINQ to Entities does not recognize the method Generic.List(int) to Generic.IEnumerable(int) method
- Flatten List<string[]> into single string with one line for each element
- How to use custom methods in LINQ query
- Cannot find an overload for "ToLookup" and the argument count: "2" LINQ
- Create a Search function in Blazor that looks up multiple entries in SQL
- Entity Framework Core: Passing a function to a Where and doing a Select will construct the object?