limsy wrote: (How do I link multiple database together for my results? I only have experience with transact SQL queries and all these layers is making me feel so lost. :P)
(eg. Select P.Id, P.name, PA.Name, PA.Description from P.Product, PA.ProductAttribute where P.Id = PA.Id)
Your Service class will use the Repository to construct the queries.