Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

Missing LINQ to SQL Classes (DBML designer) in Visual Studio 2017 RC

Tags:

linq-to-sql

visual-studio-2017

How can I add LINQ to SQL class (.dbml file) to Visual Studio 2017 RC. I can't find it. Please help, thanks.

This is the ss of Data templates.

like image 265
Çağatay Ay Avatar asked Feb 27 '17 12:02

Çağatay Ay

People also ask

How do I get LINQ to SQL in Visual Studio?

To install the LINQ to SQL tools, start the Visual Studio installer, choose Modify, then select the Individual Components tab, and then select LINQ to SQL tools under the Code Tools category.

What is Dbml in LINQ to SQL?

The DBML file is mapping that defines your classes based on your database schema. Yes, it defines your (default) connection string, but it doesn't "configure" your database at all. Linq to Sql uses a database-first approach where you have the database and model your classes after the DB schema.

1 Answers

You need to opt in to enable the designer during installation, it is not enabled by default: https://developercommunity.visualstudio.com/content/problem/4616/linq-to-sql-dbml-designer-in-not-working.html

"Editing .dbml files with a designer surface requires the LINQ to SQL tools which are not installed by default as part of any of the workloads of Visual Studio 2017. It can be installed by selecting the 'LINQ to SQL tools' item under the 'Code Tools' category in the 'Individual Components' tab of the Visual Studio installer."

like image 175
ErikEJ Avatar answered Sep 30 '22 06:09

ErikEJ
Sign in to Comment

Related questions

How to write Asynchronous LINQ query?
Purpose of EF 6.x DbContext Generator option when adding a new data item in Visual Studio
LINQ to SQL using GROUP BY and COUNT(DISTINCT)
How to use union all in LINQ?
Find (search for) table in DBML designer quickly?
Doesn't Linq to SQL miss the point? Aren't ORM-mappers (SubSonic, etc.) sub-optimal solutions?
How to create a LINQ to SQL Transaction?
Get sum of two columns in one LINQ query
Linq query with nullable sum
LINQ to SQL Where Clause Optional Criteria
To return IQueryable<T> or not return IQueryable<T> [closed]
NOLOCK with Linq to SQL
Instantiate empty IQueryable for use with Linq to sql
Best way to update LINQ to SQL classes after database schema change
TransactionScope vs Transaction in LINQ to SQL
Multiple WHERE clause in Linq
How to do a subquery in LINQ?
Linq to SQL - Return top n rows
Linq-to-SQL ToDictionary()
ASP MVC: When is IController Dispose() called?

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!