I’m working on a C# project, using a SQL Server database. I have been asked to add the possibility to work with another database.
The current database handling is done via some <db_Name>DB.dbml files and their corresponding files, so I’d like to have some file like that for the new database.
First, I have created the *.dbml file myself, I’ve added a corresponding *.layout file but that seems not to work out.
Then, I figured “Why not let Visual Studio such a file and I will fill it in afterwards”, but this led me to this other question, where the accepted answer mentions doing an “Add new item”, and then make the right choice in the “Data” chapter (“Linq-to-SQL classes”), but I believe this screenshot clearly explains my problem:
Now I have two choices:
- Either I accept I don’t have that feature in my Visual Studio 2022 environment, I don’t care and I continue adding the
*.dbmlfiles (and layout and designer files) manually and hope I will get it to work. - Either I understand that there’s no way I can get this thing to work without that
LinQ-to-SQLfeature (or its replacement).
Can anyone give me a clue? And in case LinQ-to-SQL is replaced by another feature, what’s the name?
