Well, I don't really know the syntax either, but if I were to try it myself, I'd try something like this:

        retVal = (from p in dc.tblProjects
                    where p.ProjectId == ProjectId
                    select new ProjectModel
                    {
                        ProjectId = p.ProjectId,
                        UserId = p.UserId,
                        PrimaryWarehouse = (from pw in dv.tblWarehouse
                            where pw.WarehouseID = p.PrimaryWhseId
                            select new WarehouseModel{whatever fields go here}
                            ).FirstOrDefault(),
                        SecondaryWarehouse = (from sw in dv.tblWarehouse
                            where sw.WarehouseID = p.SecondaryWhseId.Value
                            select new WarehouseModel{whatever fields go here}
                            ).FirstOrDefault(),
                        ProjectType = getProjectTypeEnum(p.ProjectType.Value),
                        CustomerCode = p.CustomerCode,
                        CustomerName = p.CustomerName,
                        ProjectName = p.ProjectName,
                        ProjectNum = p.ProjectNum,
                        Date = p.Date,
                        Comments = p.Comments
                    }
                    ).FirstOrDefault();

Will that work for you?

~~Bonnie



>I have the following method in my data layer:
>
>

>public static ProjectModel GetProject(int ProjectId)
>{
>    ProjectModel retVal = null;
>
>    using (SparesDataContext dc = getDataContext())
>    {
>        retVal = (from p in dc.tblProjects
>                    where p.ProjectId == ProjectId
>                    select new ProjectModel
>                    {
>                        ProjectId = p.ProjectId,
>                        UserId = p.UserId,
>                        PrimaryWhseId = p.PrimaryWhseId,
>                        SecondaryWhseId = p.SecondaryWhseId.Value,
>                        ProjectType = getProjectTypeEnum(p.ProjectType.Value),
>                        CustomerCode = p.CustomerCode,
>                        CustomerName = p.CustomerName,
>                        ProjectName = p.ProjectName,
>                        ProjectNum = p.ProjectNum,
>                        Date = p.Date,
>                        Comments = p.Comments
>                    }
>                    ).FirstOrDefault();
>    }
>
>    return retVal;
>}
>

>
>and here's the ProjectModel:
>
>

>    public class ProjectModel : _BaseModel
>    {
>        public int ProjectId { get; set; }
>        public int UserId { get; set; }
>        public WarehouseModel PrimaryWarehouse { get; set; }
>        public WarehouseModel SecondaryWarehouse { get; set; }
>        public ProjectType ProjectType { get; set; }
>        public string CustomerCode { get; set; }
>        public string CustomerName { get; set; }
>        public string ProjectName { get; set; }
>        public string ProjectNum { get; set; }
>        public DateTime Date { get; set; }
>        public string Comments { get; set; }
>    }
>

>Is it possible in this Linq query to pull the data from the Wharehouse table and populate the PrimaryWarehouse and SecondaryWarehouse properties with instances of those models inside this query?
>
>I'm sure it's possible, but I dobn't know the syntax.
>
>Thanks