EntityFramework-Reverse-POCO-Code-First-Generator
EntityFramework-Reverse-POCO-Code-First-Generator copied to clipboard
sjh37
Synonym four-part support
In our dev and test environments we have synonyms that cross database with three-part names. These are being generated from my template successfully, but if I point to our production environment where the database is on a different server (four-part name), the classes are not generated.
Hi @mmisnerms The generator has only been tested with synonyms on the same database server. My thanks go to @TimSirmovics as he was kind enough to add synonym support in the first place. I've labeled this case as a bug to make sure it gets done.
We are specifically only looking at synonyms from the current server using this WHERE condition when the #SynonymTargets temp table is built:
ISNULL(PARSENAME(sn.base_object_name, 4), @@SERVERNAME) = @@SERVERNAME; -- Only populate info from current server
It has been a while since I wrote this but I vaguely remember that something didn't work with cross server synonyms so I excluded them.
When I get some time I will set up a new test and see if it can be enabled.
Has there been any progress on this issue? If there is something that doesn't work with cross server synonyms, please let me know. Really appreciate this product and all the effort put into it.
Hi @mmisnerms No update on this from me. Unless its a simple fix, this case will no doubt keep getting bumped as demand for this is quite low. Sorry.
I don't think I will have time to look at this in the near future, but you can use my post above as a start if you want to investigate yourself.