Devart Forums

I can live without this feature, the multiple selection (all in one properties editing) in the Entity Developer is more important than this. Part my bad on changing the development database to do a table comparission. Will restore the other way around for future compares.

How do I initialize the datacontext with a different connectionstring for Linq to MySQL?

If i pass a connectionstring to initialize the context it doesnt seem to work if the database name is different to the one the context was created with.

Thanks.

I am getting the following error trying to orderby random in linq dotconnect mysql using the following code;


Random rnd = new Random();
var accountsrandom = (from a in dc.accounts orderby rnd.Next() select a);
int count = accountsrandom.Count();
var accountsrandom2 = accountsrandom.Skip((Convert.ToInt16(4) * (PageNumber - 1)))
.Take(Convert.ToInt16(4));
result = accountsrandom2.ToList();



and the error i get;



MySqlException (0x80004005): Unknown column '76316738' in 'order clause']
Devart.Data.MySql.bk.s() +270
Devart.Data.MySql.bk.d() +200
Devart.Data.MySql.v.a(ah[]& A_0, Int32& A_1) +134
Devart.Data.MySql.v.a(Byte[] A_0, Int32 A_1, Boolean A_2) +106
Devart.Data.MySql.a3.e() +169
Devart.Data.MySql.a3.o() +89
Devart.Data.MySql.MySqlCommand.InternalExecute(CommandBehavior behavior, IDisposable stmt, Int32 startRecord, Int32 maxRecords) +1472
Devart.Common.DbCommandBase.InternalExecute(CommandBehavior behavior, IDisposable stmt, Int32 startRecord, Int32 maxRecords, Boolean nonQuery) +48
Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior, Boolean nonQuery) +764
Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior) +38
System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader() +12
Devart.Data.Linq.Provider.DataProvider.a(b A_0, Object[] A_1, Object[] A_2, Object A_3) +1436

[LinqCommandExecutionException

new feature in latest release to select all fields in model is not working and is actually made it worst.

If i use the find in model and select all it is not allowing me to edit and now I must edit every single field where before I could select multiple fields that were the same type and edit the properties once.

Must be getting close by now. This is still extremely urgent for me.

Counting down the days...

Eagerly awaiting new version

Should have tested more before purchasing, hopefully this will be the last bug I find with dotconnect in my project and I can go live.

Thanks

Any news?

Urgent Please Help,

Latest Professional version, code works in MSSQL. I am also running similar code in a similar function, that works with dotconnect. Please provide clue where to look.


Operation could destabilize the runtime.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Security.VerificationException: Operation could destabilize the runtime.

Stack Trace:


[VerificationException: Operation could destabilize the runtime.]
lambda_method(ExecutionScope , IDataRecord ) +493
Devart.Data.Linq.Provider.ObjectReader`1.f() +56
Devart.Data.Linq.Provider.ObjectReader`1.a() +30
Devart.Data.Linq.Provider.ObjectReader`1.MoveNext() +156
System.Collections.Generic.List`1..ctor(IEnumerable`1 collection) +7665172
System.Linq.Enumerable.ToList(IEnumerable`1 source) +61

Some more info I have found.

1) The problem only occurs when I have a timestamp field with the data of "0000-00-00 00:00'. According to the mysql documentation 'With strict mode disabled, invalid dates such as '2004-04-31' are converted to '0000-00-00' and a warning is generated.' Is it possible that dotconnect is converting my "0000-00-00 00:00:00' to '0001-01-01 00:00:00' instead?

2) If I add a valid date to the data of the timestamp field the error does not occur, however the current timestamp is not inserted and the data remains the same. This can be seen in the SQL generated. Should the sql say update @timestamp set @timestamp = CURRENT_TIMESTAMP not the current data of the field?

Auto generated is set. As for the minimal datetime value, the row has a default of "CURRENT_TIMESTAMP"?????

This be my next problem, hopefully I can get dotconnect working with my project soon, it offers so much potential.

Incorrect datetime value: '00010101000000' for column 'Timestamp' at row 1
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: Devart.Data.MySql.MySqlException: Incorrect datetime value: '00010101000000' for column 'Timestamp' at row 1

[MySqlException (0x80004005): Incorrect datetime value: '00010101000000' for column 'Timestamp' at row 1]
Devart.Data.MySql.bk.q() +270
Devart.Data.MySql.bk.c() +200
Devart.Data.MySql.v.a(ah[]& A_0, Int32& A_1) +134
Devart.Data.MySql.v.a(Byte[] A_0, Int32 A_1, Boolean A_2) +106
Devart.Data.MySql.a3.e() +169
Devart.Data.MySql.a3.o() +89
Devart.Data.MySql.MySqlCommand.InternalExecute(CommandBehavior behavior, IDisposable stmt, Int32 startRecord, Int32 maxRecords) +1418
Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior) +749
System.Data.Common.DbCommand.ExecuteReader() +12
Devart.Common.DbCommandBase.ExecuteNonQuery() +64
Devart.Data.Linq.Provider.DataProvider.a(String A_0, IList`1 A_1, IDbCommand& A_2) +547

[LinqCommandExecutionException: Error on executing DbCommand.]
Devart.Data.Linq.LinqCommandExecutionException.CanThrowLinqCommandExecutionException(String message, Exception e) +79
Devart.Data.Linq.Provider.DataProvider.a(String A_0, IList`1 A_1, IDbCommand& A_2) +890
Devart.Data.Linq.v.a(MetaType A_0, q A_1, Object A_2, ModifiedMemberInfo[] A_3, Boolean A_4) +3210
Devart.Data.Linq.f.a(b A_0, Object A_1, ModifiedMemberInfo[] A_2, Boolean A_3) +534
Devart.Data.Linq.k.a(f A_0, b A_1, Boolean A_2) +143
Devart.Data.Linq.k.a(DataContext A_0, ConflictMode A_1) +2581
Devart.Data.Linq.k.b(DataContext A_0, ConflictMode A_1) +49
Devart.Data.Linq.DataContext.SubmitChanges(ConflictMode failureMode) +412
Devart.Data.Linq.DataContext.SubmitChanges() +30






----

I will make a sample app to try and replicate this.

project emailed, most likely cause updating the same field in DDD when saving table. This works in MSSQL though.

Sorry I have been so busy and couldnt do this. But if you still require a sample app I will need to reset my trail as it has expired. I would still like to fully test dotconnect with my project as I see great potential with it, but for me, mssql is such more user friendly than mysql. Though for the price mysql is a winner.

Doesn't seem to be fixed in 5.40.37

Now I get the following.

[NullReferenceException: Object reference not set to an instance of an object.]
lambda_method(ExecutionScope , Object ) +29
Devart.Data.Linq.s.a(Object A_0) +57
Devart.Data.Linq.e.a(Object A_0) +40
Devart.Data.Linq.e.a(h A_0, Object A_1, Boolean A_2) +132
Devart.Data.Linq.e.a(h A_0, Object A_1, Boolean A_2, Boolean A_3) +131
Devart.Data.Linq.j.a(h A_0, Object A_1, Boolean A_2, Boolean A_3) +91
Devart.Data.Linq.j.g(h A_0) +43
Devart.Data.Linq.r.a(Object A_0, PropertyChangingEventArgs A_1) +45
CN.ProjectCore.Core.Domain.account.SendPropertyChanging()
CN.ProjectCore.Core.Domain.account.set_lastlogindate(Nullable`1 value)
CN.ProjectCore.Core.DataAccess.Impl.AccountRepository.SaveLastLogin(account account)


I think it could be something to do with my Domain Driven Design. Also note that project works fine with microsoft linq and sql server.