'Table name' could not be resolved in the current scope or context

dapper entity-framework

Question

I saw a similar question to this, but it involved field names and not the table name issue I'm having.

I'm trying to do a simple pull from one of my tables, but I'm encountering an error that I just can't figure out.

The error message states:

'StudentBilingual' could not be resolved in the current scope or context. Make sure that all referenced variables are in scope, that required schemas are loaded, and that namespaces are referenced correctly.

            using (CEDARSEntity entity = CEDARSEntity.CreateInstance())
            {
                entity.Connection.Open();

                var result = entity.Connection.Query<StudentBilingual>(
                                        @"select [schoolYear]
                                                ,[districtOrganizationId]
                                                ,[schoolOrganizationId]
                                                ,[locationid]
                                                ,[ssid]
                                                ,[startDate]
                                                ,[recStartDate]
                                                ,[keyHash]
                                                ,[dataHash]
                                                ,[programId]
                                                ,[districtStudentCode]
                                                ,[instructionalModelId]
                                                ,[exitDate]
                                                ,[programExitReasonId]
                                                ,[placementTestScaleScore]
                                                ,[placementTestLevelId]
                                                ,[placementTestDate]
                                                ,[initialWAPlacementDate]
                                                ,[initialUSPlacementDate]
                                                ,[numMonthsUSAttendance]
                                                ,[numMonthsNonUSEducation]
                                                ,[recEndDate]
                                                ,[programdesignation]
                                                ,[placementTestCodeId]
                                                ,[gradeLevelAtPlacementId]
                                        from StudentBilingual 
                                        Where schoolYear=2011");
                entity.Connection.Close();
            }

Any help is appreciated

Popular Answer

Is StudentBilingual the Database or a table?



Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Is this KB legal? Yes, learn why
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Is this KB legal? Yes, learn why