Few things I noticed
1. Using EF and writing a SQL query inline is bad. You don't have to explicitly write sql queries
2. The following query might work for you but it's not a good practice. Say if you really want to use sql queries with multiple tables, user inner/outer joins
SELECT TOP 5 * FROM dbo.Products, dbo.ProductsPrice ORDER BY ProductID
Coming to the solution. Build a viewmodel or a class to hold the results of both tables. You should fetch and return the viewmodel.
Let me know if you have any doubts.
Thanks,