title: Mapping SQL view in code-first approach
body: <p>I have a SQL view:</p>
  
  <pre><code>WITH DirectReports (ID,ParentFolderID, ParentFolderName,FolderID,FolderName,OwnerOCID,OwnerArName,OwnerEnName,FolderType,LEVEL)
                              AS
                              (
  SELECT        e.Id AS ID,cast(cast(0 AS binary) AS uniqueidentifier) AS ParentFolderID, cast('MainFolder - ' + MainFolders.enName AS nvarchar(250)) AS ParentFolderName, 
                           e.Id AS FolderID, e.Name AS FolderName, WorkSpaces.Owner_Id AS OwnerOCID, OrgCharts.arName AS OwnerArName, OrgCharts.enName AS OwnerEnName, 
                           MainFolders.Type AS FolderType, 0 AS LEVEL
  FROM            WorkSpaceFolders AS e INNER JOIN
                           MainFolders ON MainFolders.RootFolder_Id = e.Id INNER JOIN
                           WorkSpaces ON WorkSpaces.Id = MainFolders.WorkSpace_Id INNER JOIN
                           OrgCharts ON OrgCharts.Id = WorkSpaces.Owner_Id
  WHERE        e.Root = 1 AND e.Parent_Id IS NULL
  UNION ALL
  SELECT        e.Id AS ID,e.Parent_Id AS ParentFolderID, d .FolderName AS ParentFolderName, e.Id AS FolderID, e.Name AS ChildFolderName, d .OwnerOCID, d .OwnerArName, 
                           d .OwnerEnName, d .FolderType, LEVEL + 1
  FROM            WorkSpaceFolders AS e INNER JOIN
                           DirectReports AS d ON e.Parent_Id = d .FolderID)
      SELECT        *
       FROM            DirectReports
  </code></pre>
  
  <p>and I'm using code first migrations to my database - how can I map a view to the following entity?</p>
  
  <pre><code>public class UserFolders
  {
      public Guid ID { get; set; }
      public Guid ParentFolderID { get; set; }
      public string ParentFolderName { get; set; }
      public Guid FolderID { get; set; }
      public string FolderName { get; set; }
      public Guid OwnerOCID { get; set; }
      public string OwnerArName { get; set; }
      public string OwnerEnName { get; set; }
      public int FolderType { get; set; }
      public int LEVEL { get; set; }
  }
  </code></pre>