Inserting auto generated GUID

Inserting auto generated GUID

Postby turtlevet@gmail.com » Fri 07 Jun 2013 20:07

Hello,
I created a custom sequential guid generator to use with my model and SQLite. the guidgenerator returns the guid as a string and the underlying data is stored as text. Everything was working fine (linqconnectmetro 4.2.247.1) until I purchased and installed version linqconnectmetro 4.2.262.1

Now I get this error:

A first chance exception of type 'Devart.Data.Linq.LinqCommandExecutionException' occurred in mscorlib.dll
'VetClinicLite.exe' (Managed (v4.0.30319)): Loaded 'C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.Configuration\v4.0_4.0.0.0__b03f5f7f11d50a3a\System.Configuration.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.
FAULT DETECTED!
Error on executing DbCommand.
Devart.Data.SQLite.SQLiteException: SQLite error
unrecognized token: "39c23264"
at  .(String , UInt32 , String& )
at  .()
at  .()
at Devart.Data.SQLite.SQLiteDataReader.()
at Devart.Data.SQLite.SQLiteCommand.InternalExecute(CommandBehavior behavior, IDisposable statement, Int32 startRecord, Int32 maxRecords)
at Devart.Common.DbCommandBase.InternalExecute(CommandBehavior behavior, IDisposable stmt, Int32 startRecord, Int32 maxRecords, Boolean nonQuery)
at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior, Boolean nonQuery)
at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.m8ely6dkey8cq72cwv8bdd53g5x84avl  ()
at Devart.Data.Linq.DataProvider.ExecuteQuery(String , IEnumerable`1 , IEnumerable`1 , Boolean )
END OF FAULT OUTPUT

The full guid that is generated is "39c23264-1a6b-0e90-999f-684c6e475803" and is returned as a string

Any help would be appreciated

Alberto
turtlevet@gmail.com
 
Posts: 15
Joined: Fri 07 Jun 2013 19:41

Re: Inserting auto generated GUID

Postby MariiaI » Mon 10 Jun 2013 12:04

Please try adding the following entry to your connection string - "Binary GUID=False". This parameter indicates whther to store GUID's in binary format or not.

If it doesn't help, please send us a sample project with which this error could be reproduced, so that we are able to investigate it in more details.
MariiaI
Devart Team
 
Posts: 1472
Joined: Mon 13 Feb 2012 08:17

Re: Inserting auto generated GUID

Postby turtlevet@gmail.com » Mon 10 Jun 2013 20:03

Hello,
it did not work. I will send a sample project

Alberto
turtlevet@gmail.com
 
Posts: 15
Joined: Fri 07 Jun 2013 19:41

Re: Inserting auto generated GUID

Postby MariiaI » Tue 11 Jun 2013 07:13

We are looking forward to your reply with a sample project.
MariiaI
Devart Team
 
Posts: 1472
Joined: Mon 13 Feb 2012 08:17

Re: Inserting auto generated GUID

Postby turtlevet@gmail.com » Thu 27 Jun 2013 16:21

Hello,
your latest build fixed the problem

V/r

Alberto
turtlevet@gmail.com
 
Posts: 15
Joined: Fri 07 Jun 2013 19:41

Re: Inserting auto generated GUID

Postby MariiaI » Mon 01 Jul 2013 04:56

Glad to see that the issue was resolved. If you have any further questions, feel free to contact us.
MariiaI
Devart Team
 
Posts: 1472
Joined: Mon 13 Feb 2012 08:17


Return to LinqConnect (LINQ to SQL support)