I've attached the pre-requisite attachments to visualize the issue.

I have two catalogs imported into a project, where 1 catalog has all its schema items mapped in one group (Northwind), and the other catalog into another group (Pubs).

When I generate the source code, using Group usage = 'AsSeparateProjects' and the preset 'SD.Presets.Adapter.General.Netstandard', it creates a RetrievalProcedures.cs file in each DatabaseSpecific csproj project which duplicates the functions that return the IRetrievalQuery from the first llblgen group in the second group.

So for example, the Northwind group has a "TenMostExpensiveProducts" stored procedure call. After code generation, the Pubs project has a RetrievalProcedures.cs file with methods like 'GetQueryForTenMostExpensiveProductsResultTypedView' and 'FetchTenMostExpensiveProductsResultTypedView' which don't belong in this project.

So when compiling, I get errors like:

'RetrievalProcedures.cs(297,31): error CS0103: The name 'CreateTenMostExpensiveProductsCall' does not exist in the current context', as this method is only in the Northwind project, not the Pubs project.

Is it just a matter of setting the cleanCache property in the preset somewhere? I just figure this should work out of the box on a new v5.5 clean install.

Hi MJC,

Indeed it looks weird. What build version are you using? (LLBLGen Designer -> Help -> About) Is it possible for you to attach your LLBLGen project so we can take a look at your setup and catalog?

I tried the following scenario: - New LLBLGen project using lates v5.5.2 (07-Mar-2019) - Added two catalogs from my local SQLServer (Northwind and Pubs) - Reverse Engineer all NW entities and SP objects into my model in NW group - Reverse Engineer all Pubs entities and SP objects into my model in Pubs group - Set the project setting GroupUsage as AsSeparateProjects - Generate code using NetStandard preset. Everything gets generated into the right project. - Compile all projects. All projects compiled just fine.

Please make sure you are not seeing old generated files. To make sure try to generate to an empty folder.

If the problem persists please show us your project and confirm the version you are using.

_Using 5.5 (5.5.2) RTM, March 7. _ I regenerated to a new folder, and still seeing the issue. I'm attaching my project file.

We'll look into it.

It indeed doesn't compile properly. Strange.... we'll look into what's going on...

It looks like the retrievalprocedures classes are swapped or something, the ones in nw are in the one for pubs and vice versa. Which suggests some filter error that could be as simple as a '!' where it shouldn't be

(edit) they're simply emitted in both groups so it's not a simple bad filter. There are filters in place, but apparently not working in this particular case. (entities etc. are filtered out properly, only stored procedures aren't).

Will be tomorrow (thursday) before we have a fix tho..

Bug in code generator, doesn't apply proper filter on typed views to traverse.

(edit) Fixed in next hotfix builds 5.4.6 and 5.5.3. We've to deal with 1 other issue before we'll push new builds to the website, stay tuned.

Hotfix for 5.4.6 and 5.5.3 is now available, fixing this issue

Awesome, works nicely, thanks for the fix!