C# MVC Sql Joins then Display

See more:

C#

SQL

LINQ

MVC

Hey guys, Im having trouble with a few parts of MVC and could do with some help.

I want the program to load a grid of folders onto the main page each either the modules name, ID and a button in each which acts similar to how windows explorer displays folders and subfolders. Users can rearrange the folders on the grid and click them to go to sub folders if it has any.

The database is set up like this:
Folders

FolderID, FolderName, ParentID, ClientID

Groups

GroupID, GroupName,IsGlobalAdmin, ClientID

Group permissions

ID, GroupID, FolderID, HasRead

Folder Positions

ID, FolderID, UserID, Position

I need a statement that using LINQ to Sql loads the grid based off what the group is allowed to see based off the HasRead column and if they have the same ClientID and in the order of positions that user set in the Folder positions table.

If they are a global admin the database loads all folders for that ClientID

Any links or code for me to play with? I'm struggling to find anything that covers this kind of thing in MVC, I managed it in webforms fine but this is so different I need the advise.

Thanks in advance