sergey-visual-studio/dpack

Cannot find sql files

boris008 opened this issue · 12 comments


Hello, how can I find .sql files? In previous version it works perfectly. Now when i try find, result is null. Thank you.

Click on Show all files in the file browser window:

image

It does not work. I have separate database project and some code projects. In that code projects, there is not problem. If I move sql file to code project, I find it. But in database project, I cannot find nothing.
Thank you.

Will investigate, thanks. Sorry about the delay in response. Somehow I stopped getting Github notifications.

Could you walk me through how you'd get there? What I'm looking for is steps to create correct project type, etc.

Could you walk me through how you'd get there? What I'm looking for is steps to create correct project type, etc.

Project type: It is solution with multiple project. Code part is in .NET 3.1 and Database part is in .NET Framework 4.8. It is database first project with using scaffolding for class generating.

Could you walk me through how you'd get there? What I'm looking for is steps to create correct project type, etc.

Project type: It is solution with multiple project. Code part is in .NET 3.1 and Database part is in .NET Framework 4.8. It is database first project with using scaffolding for class generating.

Thanks. Unfortunately, I don't venture out into that part of VS. Could you walk me through creating that type of solution? What I'm mainly interested in is what project types are selected, dev language, make up of the project, etc.

gsjen commented

Same issue here. The project type is SQL Server Database Project:
image

These projects consist almost exclusively of .sql files containing SQL code.

I see. Which SKU does that option available in?

gsjen commented

It is part of SQL Server Data Tools, which I believe is included in all versions of VS 2022.

Thanks. I'll check it out.

Hopefully it's fixed. Take a look at this post with posted new beta.

New release should be out shortly.