Last post Oct 30, 2019 09:57 AM by cicciuzzo
Oct 29, 2019 07:33 PM|cicciuzzo|LINK
Oct 29, 2019 07:51 PM|bruce (sqlwork.com)|LINK
EF does not support cross database (or dbcontext) joins. you can move the code to a stored proc, and call the proc, or create views in the one database that reference the tables in the other database. if not on the same server, you will need to linked server
to create the views.
Oct 29, 2019 10:51 PM|mgebhard|LINK
Another options are moving the two table from the Identity store to the isolated database or adding claims to the user that identifies the db-badge and user info. Use the claims to filter the isolated table and insert user data.
Oct 30, 2019 09:57 AM|cicciuzzo|LINK
Thanks for help.. I will try it