If I were to extricate my current membership provider from my solution, i.e. as a dll and expose it as a web service with it's own db, how would I model the relationships with regards to SOA design.

For example

I have a table:

USER id, name, lastname, username, password, role.

and table

PRODUCT id, name, price, createdate, userid

the foreign key being userid to table user.

How would I model the relationship and/or query the db.

If I wanted to get all products that were uploaded today for example, before I would query:

SELECT u.name, u.lastname, u.username, p.* FROM PRODUCT p INNER JOIN USER u ON p.userid = u.id WHERE createdate = '05/05/2010'

Now that I don't have the table within the database how would I perform this query?

Thanks.