Custom Authentication SL4 WCF RIA

My client has a database (TS) for a project I'm working on. This database has a Stored Procedure called Logon. Within that SPROC is a call to a second database (RRA), which is their custom authentication DB that is used across all of their projects. The result of this call is the Role(s) a user is assigned to (assuming authentication passes, of course).

I'm attempting to do this via WCF RIA Services. When I create my ADO.NET Entity Data Model, I'm not sure开发者_JAVA百科 which Data connection I should use - the one that connects to TS, or the one that connects to RRA. I'm going on the assumption that its TS.

Beyond that assumption, I'm still stuck. I know I can add an Import Function to that Logon SPROC. Where do I go from here?

I agree that you should target the TS database.

Here's a walkthrough of using stored procs.

http://www.robbagby.com/entity-framework/entity-framework-modeling-select-stored-procedures/

And here's an answer to how you can create a custom authentication using RIA Services.

RIA Services: How can I create custom authentication?