Inserting auto generated GUID
Posted: 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
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