Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Appearance settings

EF6 and iQueryable.Skip(n).Take(k) problem #149

Copy link
Copy link
@Civickas

Description

@Civickas
Issue body actions

On code "iQueryable.Skip(n).Take(k)" I get error:
"ERROR: 42703: column Extent1.User_Id does not exist"
And other:
"ERROR: 42703: column Extent1.C1 does not exist"
I guess the similar problem is here:
http://pgfoundry.org/forum/forum.php?thread_id=15594&forum_id=519&group_id=1000140

Any fix?

More information:
//query of iQueryable
SELECT "Extent1"."Id" AS "Id","Extent1"."ContractInitiatedDate" AS "ContractInitiatedDate","Extent1"."ContractSentDate" AS "ContractSentDate","Extent1"."ContractSignedDate" AS "ContractSignedDate","Extent1"."UserId" AS "UserId","Extent1"."ResponsibleUserId" AS "ResponsibleUserId","Extent2"."Id" AS "Id1","Extent2"."Email" AS "Email","Extent2"."Phone" AS "Phone","Extent2"."Password" AS "Password","Extent2"."Firstname" AS "Firstname","Extent2"."Lastname" AS "Lastname","Extent2"."Position" AS "Position","Extent2"."Rights" AS "Rights","Extent2"."Ip" AS "Ip","Extent2"."LastActive" AS "LastActive","Extent2"."ProjectDatabaseId" AS "ProjectDatabaseId","Extent2"."CountryId" AS "CountryId","Extent2"."CarrierId" AS "CarrierId","Extent3"."Id" AS "Id2","Extent3"."Email" AS "Email1","Extent3"."Phone" AS "Phone1","Extent3"."Password" AS "Password1","Extent3"."Firstname" AS "Firstname1","Extent3"."Lastname" AS "Lastname1","Extent3"."Position" AS "Position1","Extent3"."Rights" AS "Rights1","Extent3"."Ip" AS "Ip1","Extent3"."LastActive" AS "LastActive1","Extent3"."ProjectDatabaseId" AS "ProjectDatabaseId1","Extent3"."CountryId" AS "CountryId1","Extent3"."CarrierId" AS "CarrierId1","Extent5"."Id" AS "Id3","Extent5"."Name" AS "Name","Extent5"."PhoneCode" AS "PhoneCode","Extent4"."Id" AS "Id4","Extent4"."Name" AS "Name1","Extent1"."User_Id" AS "User_Id","Extent1"."User_Id1" AS "User_Id1" FROM "public"."Prospect" AS "Extent1" INNER JOIN "public"."User" AS "Extent2" ON "Extent1"."ResponsibleUserId"="Extent2"."Id" INNER JOIN "public"."User" AS "Extent3" ON "Extent1"."UserId"="Extent3"."Id" INNER JOIN "public"."Carrier" AS "Extent4" ON "Extent3"."CarrierId"="Extent4"."Id" INNER JOIN "public"."Country" AS "Extent5" ON "Extent3"."CountryId"="Extent5"."Id" ORDER BY "Extent2"."Firstname" ASC ,"Extent2"."Lastname" ASC ,"Extent4"."Name" ASC
//error
[NpgsqlException (0x80004005): ERROR: 42703: column Extent1.User_Id does not exist] Npgsql.<ProcessBackendResponses_Ver_3>d__9.MoveNext() +4069 Npgsql.ForwardsOnlyDataReader.GetNextResponseObject(Boolean cleanup) +1215 Npgsql.ForwardsOnlyDataReader.GetNextRowDescription() +128 Npgsql.ForwardsOnlyDataReader.NextResultInternal() +89 Npgsql.ForwardsOnlyDataReader..ctor(IEnumerable1 dataEnumeration, CommandBehavior behavior, NpgsqlCommand command, NotificationThreadBlock threadBlock, Boolean preparedStatement, NpgsqlRowDescription rowDescription) +216 Npgsql.NpgsqlCommand.GetReader(CommandBehavior cb) +737 Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior cb) +262 Npgsql.NpgsqlCommand.ExecuteDbDataReader(CommandBehavior behavior) +41 System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior) +10 System.Data.Entity.Infrastructure.Interception.<>c__DisplayClassb.<Reader>b__8() +69 System.Data.Entity.Infrastructure.Interception.InternalDispatcher1.Dispatch(Func1 operation, TInterceptionContext interceptionContext, Action1 executing, Action1 executed) +93 System.Data.Entity.Infrastructure.Interception.DbCommandDispatcher.Reader(DbCommand command, DbCommandInterceptionContext interceptionContext) +319 System.Data.Entity.Internal.InterceptableDbCommand.ExecuteDbDataReader(CommandBehavior behavior) +240 System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior) +10 System.Data.Entity.Core.EntityClient.Internal.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior) +97

//another query of iQueryable
SELECT "Project1"."Id" AS "Id","Project1"."Name" AS "Name","Project1"."C2" AS "C1","Project1"."Id1" AS "Id1","Project1"."Email" AS "Email","Project1"."Phone" AS "Phone","Project1"."Password" AS "Password","Project1"."Firstname" AS "Firstname","Project1"."Lastname" AS "Lastname","Project1"."Position" AS "Position","Project1"."Rights" AS "Rights","Project1"."Ip" AS "Ip","Project1"."LastActive" AS "LastActive","Project1"."ProjectDatabaseId" AS "ProjectDatabaseId","Project1"."CountryId" AS "CountryId","Project1"."CarrierId" AS "CarrierId","Project1"."Id2" AS "Id2","Project1"."Name1" AS "Name1" FROM (SELECT cast(FALSE as boolean) AS "C1","Extent1"."Id" AS "Id","Extent1"."Name" AS "Name","Extent2"."Id" AS "Id1","Extent2"."Email" AS "Email","Extent2"."Phone" AS "Phone","Extent2"."Password" AS "Password","Extent2"."Firstname" AS "Firstname","Extent2"."Lastname" AS "Lastname","Extent2"."Position" AS "Position","Extent2"."Rights" AS "Rights","Extent2"."Ip" AS "Ip","Extent2"."LastActive" AS "LastActive","Extent2"."ProjectDatabaseId" AS "ProjectDatabaseId","Extent2"."CountryId" AS "CountryId","Extent2"."CarrierId" AS "CarrierId","Extent3"."Id" AS "Id2","Extent3"."Name" AS "Name1", CASE WHEN ("Extent2"."Id" IS NULL ) THEN (CAST (NULL AS int4)) ELSE (1) END AS "C2" FROM "public"."ProjectDatabase" AS "Extent1" LEFT OUTER JOIN "public"."User" AS "Extent2" INNER JOIN "public"."Carrier" AS "Extent3" ON "Extent2"."CarrierId"="Extent3"."Id" ON "Extent1"."Id"="Extent2"."ProjectDatabaseId") AS "Project1" ORDER BY "Project1"."C1" ASC ,"Project1"."Id" ASC ,"Project1"."C2" ASC
//error
[NpgsqlException (0x80004005): ERROR: 42703: column Extent1.C1 does not exist] Npgsql.<ProcessBackendResponses_Ver_3>d__9.MoveNext() +4069 Npgsql.ForwardsOnlyDataReader.GetNextResponseObject(Boolean cleanup) +1215 Npgsql.ForwardsOnlyDataReader.GetNextRowDescription() +128 Npgsql.ForwardsOnlyDataReader.NextResultInternal() +89 Npgsql.ForwardsOnlyDataReader..ctor(IEnumerable1 dataEnumeration, CommandBehavior behavior, NpgsqlCommand command, NotificationThreadBlock threadBlock, Boolean preparedStatement, NpgsqlRowDescription rowDescription) +216 Npgsql.NpgsqlCommand.GetReader(CommandBehavior cb) +737 Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior cb) +262 Npgsql.NpgsqlCommand.ExecuteDbDataReader(CommandBehavior behavior) +41 System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior) +10 System.Data.Entity.Infrastructure.Interception.<>c__DisplayClassb.<Reader>b__8() +69 System.Data.Entity.Infrastructure.Interception.InternalDispatcher1.Dispatch(Func1 operation, TInterceptionContext interceptionContext, Action1 executing, Action1 executed) +93 System.Data.Entity.Infrastructure.Interception.DbCommandDispatcher.Reader(DbCommand command, DbCommandInterceptionContext interceptionContext) +319 System.Data.Entity.Internal.InterceptableDbCommand.ExecuteDbDataReader(CommandBehavior behavior) +240 System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior) +10 System.Data.Entity.Core.EntityClient.Internal.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior) +97

On these iQueryable I do "iQueryable.Skip(n).Take(k)" and get errors.

I am using Npgsql 2.1.0-beta1 + Npgsql.EntityFramework

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions

      Morty Proxy This is a proxified and sanitized view of the page, visit original site.