اضافه نشدن view به entity

[mory123]

با سلام خدمت اساتید محترم .
داخل یک برنامه می خوام یک view را به مدل entity که با ADO .net Entity model درست شده اضافه کنم اما پیغام زیر را میدهد:
Error 6013: The table/view 'KimiaDataBAse_03.dbo.vwRAMReqRouFind' does not have a primary key defined and no valid primary key could be inferred. This table/view has been excluded. To use the entity, you will need to review your schema, add the correct keys, and uncomment it.
لطفا راهنماییم کنید. با تشکر.

[malizergani]

سلام دوست عزیز

لطفاً کدتون رو قرار بدین تا بهتر راهنمائیتون کنم انشاالله

[mory123]

SELECT dbo.tblRAMRepairReq.ID, dbo.tblRAMRepairReq.Code, dbo.tblRAMRepairReq.CreatorID, dbo.tblBISUser.Alias AS Creator, dbo.tblRAMRepairReq.CreateDate, dbo.tblRAMRepairReq.PVCreateDate,
dbo.tblRAMRepairReq.PriorityTypeID, dbo.tblRAMPriorityTypeL.Description AS PriorityType, dbo.tblRAMRepairReq.ReqEmployeeID,
tblBISEMPloyee_2.FirstName + ' ' + tblBISEMPloyee_2.LastName AS ReqEmployee, dbo.tblRAMRepairReq.ReqDate, dbo.tblRAMRepairReq.PVReqDate, dbo.tblRAMRepairReq.FAAssetID,
dbo.tblRAMRepairReq.ISAssetStop, dbo.tblRAMRepairReq.StopStartDate, dbo.tblRAMRepairReq.PVStopStartDate, dbo.tblRAMRepairReq.StopStartHour, dbo.tblRAMRepairReq.Notes,
dbo.tblRAMRepairReq.ConfirmerAnswer, dbo.tblRAMRepairReq.ConfirmerEmployeeID, tblBISEMPloyee_1.FirstName + ' ' + tblBISEMPloyee_1.LastName AS ConfirmerEmployee,
dbo.tblCFAAssets.LabelNumber AS AssetCode, dbo.tblCFAAssets.Code AS LabelNumber, dbo.tblCFAAssets.Name, dbo.tblCFAAssets.ClassID, dbo.tblCFAAssets.CurrentLocationID,
dbo.tblCFAAssets.CurrentStatusID, dbo.tblCFAClasses.Name AS Class, dbo.tblCFALocation.Name AS CurrentLocation, dbo.vwRAMRepairReqRoutin.RoutineID,
dbo.vwRAMRepairReqRoutin.FloatingDays, dbo.vwRAMRepairReqRoutin.PreRequisitRoutinID, dbo.vwRAMRepairReqRoutin.BeginDate, dbo.vwRAMRepairReqRoutin.PVBeginDate,
dbo.vwRAMRepairReqRoutin.EndDate, dbo.vwRAMRepairReqRoutin.PVEndDate, dbo.vwRAMRepairReqRoutin.PreRoutin, dbo.vwRAMRepairReqRoutin.Routin,
dbo.vwRAMRepairReqRoutin.PriorityType AS PriorityTypeR, dbo.vwRAMRepairReqRoutin.PriorityTypeID AS PriorityTypeIDR, dbo.vwRAMRepairReqRoutin.IsStopedDuringRepair,
dbo.vwRAMRepairReqRoutin.IsNeedCBM, dbo.vwRAMRepairReqRoutin.IsNeedTechnicalInspection , dbo.vwRAMRepairReqRoutin.IsNeedPermit, dbo.vwRAMRepairReqRoutin.RoutinNetTypeID,
dbo.vwRAMRepairReqRoutin.RoutinNetType, dbo.vwRAMRepairReqRoutin.DepartmentID, dbo.vwRAMRepairReqRoutin.EstimatedStopDurationHrs,
dbo.vwRAMRepairReqRoutin.EstimatedExecuteDurationH rs
FROM dbo.tblCFALocation RIGHT OUTER JOIN
dbo.tblCFAAssets ON dbo.tblCFALocation.ID = dbo.tblCFAAssets.CurrentLocationID LEFT OUTER JOIN
dbo.tblCFAClasses ON dbo.tblCFAAssets.ClassID = dbo.tblCFAClasses.ID RIGHT OUTER JOIN
dbo.tblRAMRepairReq ON dbo.tblCFAAssets.ID = dbo.tblRAMRepairReq.FAAssetID LEFT OUTER JOIN
dbo.tblBISEmployee AS tblBISEMPloyee_2 ON dbo.tblRAMRepairReq.ReqEmployeeID = tblBISEMPloyee_2.ID LEFT OUTER JOIN
dbo.tblBISEmployee AS tblBISEMPloyee_1 ON dbo.tblRAMRepairReq.ConfirmerEmployeeID = tblBISEMPloyee_1.ID LEFT OUTER JOIN
dbo.tblRAMPriorityTypeL ON dbo.tblRAMRepairReq.PriorityTypeID = dbo.tblRAMPriorityTypeL.ID LEFT OUTER JOIN
dbo.tblBISUser ON dbo.tblRAMRepairReq.CreatorID = dbo.tblBISUser.ID FULL OUTER JOIN
dbo.vwRAMRepairReqRoutin ON dbo.tblRAMRepairReq.ID = dbo.vwRAMRepairReqRoutin.RepairReqID

[malizergani]

ایرادشو گفته KimiaDataBAse_03.dbo.vwRAMReqRouFind

عکس از دیاگرام view بگیرید

[malizergani]

سلام دوست عزیز با entity مشکلی ندارید که از این طریق راهنمائیتون کنم

[mory123]

130316
دیاگرام

[malizergani]

از این جدول vwRAMReqRouFind چرا استفاده نکردین

[mory123]

اونایی که vw اولشون داره view هستن و اونایی که tbl اولشون داره table.
به نظر شما tblfalocation باید علامت کلید کنارش باشه مثل tblCFAASSET?

[malizergani]

خب این خطا میگه vwRAMReqRouFind کلید اصلی نداره یا کلید اصلی رو چک کن