The issue is in your table. The sf_PageBase
uses both Application
columns to create unique identifier not just the Id. So you will have to create the same type of unique identifier for your custom table like I did in the attached screen shot. You must map both Application
columns for the foreign key to create a 1:1 relation.
We do not recommend
you creating such tables and constraints because Sitefinity uses Nolics ORM and such actions may brake the ORM's ability to read/write data. Also your project upgrades the database to newer versions of Sitefinity when you update the assemblies, and this may result in some serious errors with the relations.
Based on my understanding on what your trying to achieve, I suggest you this approach:
1. Create your pages and blogs - A and B
2. On page A place BlogPost
control that is filtered to show only Blog A
3. Create Role A
4. On the page's properties tab set Anonymous access
5. On the page's permissions click Break inheritance
. This will make the page to have it's own set of permissions.
6. Give View
permissions to Role A
Repeat the same procedure for Page B, Blog B and Role B
The reason for this is that by denying Anonymous access you will force the user to go through Login process before he can view the page.
Hope this helps.
the Telerik team