search

zzzprojects / EntityFramework-Extensions

Entity Framework Bulk Operations | Improve Entity Framework performance with Bulk SaveChanges, Insert, update, delete and merge for SQL Server, SQL Azure, SQL Compact, MySQL and SQLite.
https://entityframework-extensions.net
342 stars 57 forks source link

MySQL EF6 UpdateFromQuery error #304

Open sginfoocio opened 4 years ago

sginfoocio commented 4 years ago

Description

When update a value using this method send this excepcion, the correct value is amou.Torneos_Jugadores not amou.amou.

Exception

Table 'amou.amou.Torneos_Jugadores' doesn't exist

Exception message:

en MySql.Data.MySqlClient.MySqlStream.ReadPacket()
   en MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
   en MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId)
   en MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
   en MySql.Data.MySqlClient.MySqlDataReader.NextResult()
   en MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
   en MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()
   en System.Data.Entity.Infrastructure.Interception.DbCommandDispatcher.<NonQuery>b__0(DbCommand t, DbCommandInterceptionContext`1 c)
   en System.Data.Entity.Infrastructure.Interception.InternalDispatcher`1.Dispatch[TTarget,TInterceptionContext,TResult](TTarget target, Func`3 operation, TInterceptionContext interceptionContext, Action`3 executing, Action`3 executed)
   en System.Data.Entity.Infrastructure.Interception.DbCommandDispatcher.NonQuery(DbCommand command, DbCommandInterceptionContext interceptionContext)
   en .Execute[T](IQueryable`1 query, Expression`1 updateFactory)
   en DbContextExtensions.[](IQueryable`1 , Expression`1 , Action`1 , Boolean )
   en DbContextExtensions.UpdateFromQuery[TEntity](IQueryable`1 query, Expression`1 updateExpression, Action`1 bulkOperationFactory)
   en DbContextExtensions.UpdateFromQuery[TEntity](IQueryable`1 query, Expression`1 updateExpression)
   en Diseño.Clases.SorteoParejas.GenerarClasificacion() en C:\Proyectos\Mustotal Aplicacion\Diseño\Clases\SorteoParejas.cs: línea 134
   en Diseño.FormTorneoParejas.<CargarRonda>b__22_1() en C:\Proyectos\Mustotal Aplicacion\Diseño\Forms\FormTorneoParejas.cs: línea 562
   en System.Threading.Tasks.Task.InnerInvoke()
   en System.Threading.Tasks.Task.Execute()

Fiddle or Project (Optional)

If you are able,

Provide a Fiddle that reproduces the issue: https://dotnetfiddle.net/Uqe9sf

Or provide a project/solution that we can run to reproduce the issue.

Otherwise, make sure to include as much information as possible to help our team to reproduce the issue.

Note: More information you provide, faster we can implement a solution.

Further technical details

JonathanMagnan commented 4 years ago

Hello @sginfoocio ,

Which version of our library are you using?

sginfoocio commented 4 years ago

Hi, The version are: Z.EntityFramework.Extensions 4.0.12 Z.BulkOperations 3.0.3

Thanks

sginfoocio commented 4 years ago

Any solution? Thanks?

JonathanMagnan commented 4 years ago

Hello @sginfoocio ,

Sorry for the delay, my developer looked at it yesterday and today but was not able to reproduce it as we should already support this case (when the table starts with the schema, we don't append the schema).

It's possible for you to provide a project that has this issue? You can send it in private here: info@zzzprojects.com

JonathanMagnan commented 4 years ago

Hello @sginfoocio,

A quick reminder that we are here to assist you!

Don't hesitate to provide a project with the issue here is our email: info@zzzprojects.com

Looking forward to hearing from you,

Jon

JonathanMagnan commented 4 years ago

Hello @sginfoocio,

Since our last conversation, we haven't heard from you.

Don't hesitate to provide a project with the issue.

You can send it to our email: info@zzzprojects.com

Best regards,

Jon

sginfoocio commented 4 years ago

Hi,

Sorry for the delay, I want to try an empty project with the same database and see if it gives the problem.

But I haven't had 1 second.

Thanks

Este mensaje se envía desde el correo electrónico de SG Informática y Ocio SLU. Contiene por lo tanto secretos de empresa tutelados por las leyes de España, Unión Europea y otros Estados. Si Vd. Lo recibiera por error o sin ser una de las personas indicadas en el encabezamiento, deberá destruirlo sin copiarlo ni comunicarlo e informar inmediatamente por correo electrónico al emisor del mensaje. Las personas y entidades que violen sus deberes de confidencialidad podrán ser perseguidas ante los Tribunales de Justicia al amparo de la legislación civil, penal y administrativa nacional e internacional.

Rubén Cebreiros

SG Informática y Ocio Ourense SLU

TEL +34 988 391 353 FAX +34 988 611 994 Mobile +34 678 656 167 mailto:info@sginfoocio.com info@sginfoocio.com http://www.sginfoocio.com/ www.sginfoocio.com

De: Jonathan Magnan notifications@github.com Enviado el: viernes, 29 de noviembre de 2019 14:29 Para: zzzprojects/EntityFramework-Extensions EntityFramework-Extensions@noreply.github.com CC: sginfoocio ruben@sginfoocio.com; Mention mention@noreply.github.com Asunto: Re: [zzzprojects/EntityFramework-Extensions] MySQL EF6 UpdateFromQuery error (#304)

Hello @sginfoocio https://github.com/sginfoocio ,

Since our last conversation, we haven't heard from you.

Don't hesitate to provide a project with the issue.

You can send it to our email: info@zzzprojects.com mailto:info@zzzprojects.com

Best regards,

Jon

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/zzzprojects/EntityFramework-Extensions/issues/304?email_source=notifications&email_token=AHR4GTEDFP5O6JZUJCMORVDQWEKKTA5CNFSM4JMZVOUKYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOEFO3Q5Q#issuecomment-559790198 , or unsubscribe https://github.com/notifications/unsubscribe-auth/AHR4GTCMKEAL35Q3T4B2NIDQWEKKTANCNFSM4JMZVOUA . https://github.com/notifications/beacon/AHR4GTFDGLNK6A4ICHBTBZTQWEKKTA5CNFSM4JMZVOUKYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOEFO3Q5Q.gif

JonathanMagnan commented 4 years ago

Hello @sginfoocio,

We understand, we all have unexpected tasks along the way!

Feel free to contact us once you try it out.

Looking forward to hearing from you,

Jon

JonathanMagnan commented 4 years ago

Hello @sginfoocio ,

A quick follow up to see if you had the chance to work on a project with the issue?

Looking forward to hearing from you,

Jon

sginfoocio commented 4 years ago

Hi I send the poryect to info@zzzprojects.com.

Looking forward to hearing from you ;)

JonathanMagnan commented 4 years ago

Awesome @sginfoocio,

Our developer will look at it and get back to you!

We will keep in touch :)

sginfoocio commented 4 years ago

Thanks,