Entity Framework Update statement generating invalid SQL for Firebird

1
votes

I'm using Firebird 2.5.0 with the Entity Framework, which has been working well. However, recently I have changed something (I presume) and now the SQL that is being generated when I try to save my changes is not valid for Firebird:

update ( select [fields] from [table]) set [field] = @p0 where ([keyfieldn = @pn])

As far as I know, Firebird 2.5.0 does not support this syntax, and when I try to save changes I get back a SQL error that says as much ( "Token unknown, column 8: (" )

I'm not sure what to do now. What would cause the UpdateTranslator instance to generate this SQL instead of whatever it must have been generating before I broke it?

1
entity-framework-4firebirdfirebird2.5
Are you using correct provider? firebirdsql.org/index.php?op=files&id=netprovider - Ladislav Mrnka
yep, 2.6 version. It retrieves data properly, I just can't do updates anymore. - DaveK

1 Answers

1
votes

I went back through the edmx file and found that I had gotten some 'DefiningQuery' elements when I had it pull in some new fields from the database. I couldn't find any way to access those settings in the interface, so I just deleted them from the file and it is working correctly again.