"Implementation limit exceeded"
-------------------------------

                 Key: DNET-518
                 URL: http://tracker.firebirdsql.org/browse/DNET-518
             Project: .NET Data provider
          Issue Type: Bug
         Environment: Win7 x64 - VS 2012 - Firebird 2.5.x - .Net Provider 
3.1.1.0
            Reporter: Rand Random
            Assignee: Jiri Cincura


I am still facing the issue when I want to update my EDMX Model, as described 
here

http://tracker.firebirdsql.org/browse/DNET-513
http://tracker.firebirdsql.org/browse/DNET-514

Just to make sure I am using the version 3.1.1.0 I did the following in my code:

using (var conx = new EntityModel())
            {
                var bla = conx.TabAccounts.Where(x => x.AccNr == 
"1001").Single();

            }

Which sucessfully run, and outputed to this sql query:

SELECT FIRST (2) 
"B"."IDACCOUNT" AS "IDACCOUNT", 
"B"."IDCOMPANY" AS "IDCOMPANY", 
"B"."IDPARENT" AS "IDPARENT", 
"B"."ACCNR" AS "ACCNR", 
"B"."ACCNRSUB" AS "ACCNRSUB", 
"B"."FLAGISSPLIT" AS "FLAGISSPLIT", 
"B"."FLAGISSYSTEMACCOUNT" AS "FLAGISSYSTEMACCOUNT", 
"B"."TEXTACCOUNTGL" AS "TEXTACCOUNTGL"
FROM "TABACCOUNT" AS "B"
WHERE CAST(_UTF8'1001' AS VARCHAR(8191)) = "B"."ACCNR"

As you notice the VARCHAR(8191) is fixed, but on Update Model from Database it 
fails.

Also I would like to mention that the .Single method here gets parsed to 
"SELECT FIRST (2) ...." shouldnt it be "SELECT FIRST (1)..." ?

Hope you can help me out.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: 
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

------------------------------------------------------------------------------
Introducing Performance Central, a new site from SourceForge and 
AppDynamics. Performance Central is your source for news, insights, 
analysis and resources for efficient Application Performance Management. 
Visit us today!
http://pubads.g.doubleclick.net/gampad/clk?id=48897511&iu=/4140/ostg.clktrk
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Reply via email to