Join Sql and Gridview

[kaflekk]

Hi, I'm new to ORM.Net. Please help to display the value from table which primary key is used  as foreign key. E.g.

create table Group
(
GoupID int identifier(1,1) primary key
GroupName varchar(50)
)

create table Product
(
ProductID int identifier(1001,1) primary key,
ProductName varchar(50),
GroupID int foreign key references Group(GroupID),
)

Now my i want result of sql "select p.ProductName, g.GroupName from Product p join Group g on p.GroupID = g.GroupID"

I want such result to be displayed in gridview.

Please guide me how to get that result using FetchPath or JoinPath