EDM and Guid

nilssonm · Post by **nilssonm** » Thu 14 May 2009 20:32

Is there a problem with the Guid support for MySql and Entity Framework again? This is what I got in my test program.

Unhandled Exception: System.Data.UpdateException: An error occurred while updating the entries. See the InnerException for details. ---> System.Data.EntityCommandCompilationException: An error occurred while preparing the command definition. See the inner exception for details. ---> System.NotSupportedException: DbType Guid is not supported.
   at Devart.Data.MySql.bj.a(DbType A_0)
   at Devart.Data.MySql.MySqlParameter.set_DbType(DbType value)
   at Devart.Common.Entity.l.a.b(DbParameterBase A_0, TypeUsage A_1)
   at Devart.Common.Entity.l.a.a(DbParameterBase A_0, TypeUsage A_1)
   at Devart.Common.Entity.l.a.a(Object A_0, TypeUsage A_1)
   at Devart.Common.Entity.l.a.a(DbConstantExpression A_0)
   at Devart.Common.Entity.l.a(DbInsertCommandTree A_0, DbCommand A_1, DbProviderManifest A_2)
   at Devart.Data.MySql.Entity.c.a(DbCommandTree A_0, DbConnection A_1, DbProviderManifest A_2)
   at Devart.Data.MySql.Entity.MySqlEntityProviderServices.b(DbProviderManifest A_0, DbCommandTree A_1)
   at System.Data.Common.DbProviderServices.CreateCommand(DbCommandTree commandTree)
   at System.Data.Mapping.Update.Internal.UpdateTranslator.CreateCommand(DbModificationCommandTree commandTree)
   --- End of inner exception stack trace ---
   at System.Data.Mapping.Update.Internal.UpdateTranslator.CreateCommand(DbModificationCommandTree commandTree)
   at System.Data.Mapping.Update.Internal.DynamicUpdateCommand.CreateCommand(UpdateTranslator translator, Dictionary`2 identifierValues)
   at System.Data.Mapping.Update.Internal.DynamicUpdateCommand.Execute(UpdateTranslator translator, EntityConnection connection, Dictionary`2 identifi
erValues, List`1 generatedValues)
   at System.Data.Mapping.Update.Internal.UpdateTranslator.Update(IEntityStateManager stateManager, IEntityAdapter adapter)
   --- End of inner exception stack trace ---
   at System.Data.Mapping.Update.Internal.UpdateTranslator.Update(IEntityStateManager stateManager, IEntityAdapter adapter)
   at System.Data.Objects.ObjectContext.SaveChanges(Boolean acceptChangesDuringSave)
   at DevArtTest.Program.Main(String[] args) in D:\Work\Test\DevArtTest\Program.cs:line 30

Regards,
Mats

nilssonm · Post by **nilssonm** » Fri 15 May 2009 07:15

Here is a complete with database example to reproduce the problem.

The Project

/Mats

AndreyR · Post by **AndreyR** » Fri 15 May 2009 12:28

Thank you for the test project, we are investigating the problem.
I will let you know about the results.

nilssonm · Post by **nilssonm** » Fri 15 May 2009 12:36

Sound great!

I'm hoping for a quick response.

Regards,
Mats

AndreyR · Post by **AndreyR** » Tue 19 May 2009 14:02

This problem is fixed, look forward to the next build.

nilssonm · Post by **nilssonm** » Tue 19 May 2009 14:11

Exciting

Do you have a timeframe for that?

/Mats

AndreyR · Post by **AndreyR** » Tue 19 May 2009 14:58

We plan to release the new build this week.

nilssonm · Post by **nilssonm** » Tue 19 May 2009 15:11

OK, thanks for your quick responses.

/Mats

Shalex · Post by **Shalex** » Fri 22 May 2009 16:06

The new build of dotConnect for MySQL 5.20.33 is available for download now.
It can be downloaded from http://www.devart.com/dotconnect/mysql/download.html (trial version) or from Registered Users' Area (for users with valid subscription only).
For more information, please refer to http://www.devart.com/forums/viewtopic.php?t=14910 .