Issue Details (XML | Word | Printable)

Key: DNET-427
Type: Bug Bug
Status: Closed Closed
Resolution: Won't Fix
Priority: Major Major
Assignee: Jiri Cincura
Reporter: Damasio
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
.NET Data provider

Query error in Firebird

Created: 30/Apr/12 01:40 PM   Updated: 04/Nov/16 06:22 AM
Component/s: Entity Framework
Affects Version/s: 2.7.5
Fix Version/s: None

File Attachments: 1. File METADATA.SQL (3 kB)
2. Zip Archive WebApplication1.zip (589 kB)

Environment: C# Entity Framework - Visual Studio .Net 4.0
Issue Links:
Depend
 


 Description  « Hide
"Dynamic SQL Error
SQL error code = -104
Token unknown - line 8, column 3
OUTER"


protected void LinqDataSourcePedidos_QueryCreated(object sender, QueryCreatedEventArgs e)
        {
            var q = e.Query.Cast<PED>();
            var result = (from t in q
                          select new
                          {
                              PEDPOS_POSICAO = (from pedpos in t.PEDPOS
                                                where
                                                  t.PED_ID == pedpos.PED_ID &&
                                                  pedpos.PEDPOS_ID ==
                                                    t.PEDPOS.FirstOrDefault().PEDPOS_ID
                                                select new
                                                {
                                                    pedpos.PEDPOS_POSICAO
                                                }).FirstOrDefault().PEDPOS_POSICAO,
                              PED_ID = t.PED_ID
                          });
            e.Query = result;
        }




 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Damasio made changes - 30/Apr/12 01:46 PM
Field Original Value New Value
Priority Major [ 3 ] Critical [ 2 ]
Component/s Entity Framework support [ 10110 ]
Component/s ADO.NET Provider [ 10041 ]
Jiri Cincura made changes - 19/May/12 12:44 PM
Status Open [ 1 ] In Progress [ 3 ]
Jiri Cincura made changes - 19/May/12 12:45 PM
Priority Critical [ 2 ] Major [ 3 ]
Damasio made changes - 25/May/12 03:31 AM
Attachment METADATA.SQL [ 12160 ]
Attachment WebApplication1.zip [ 12161 ]
Jiri Cincura made changes - 25/May/12 09:25 AM
Status In Progress [ 3 ] Closed [ 6 ]
Resolution Won't Fix [ 2 ]
Jiri Cincura made changes - 04/Nov/16 06:22 AM
Link This issue block progress on DNET-711 [ DNET-711 ]