EntityFramework-Extensions icon indicating copy to clipboard operation
EntityFramework-Extensions copied to clipboard

MySQL EF6 UpdateFromQuery error

Open sginfoocio opened this issue 6 years ago • 12 comments

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.

  • Make sure the project compile
  • Make sure to provide only the code that is required to reproduce the issue, not the whole project
  • You can send private code here: [email protected]

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

  • EF version:
  • EF Extensions version:
  • Database Provider:

sginfoocio avatar Nov 13 '19 11:11 sginfoocio

Hello @sginfoocio ,

Which version of our library are you using?

JonathanMagnan avatar Nov 13 '19 14:11 JonathanMagnan

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

Thanks

sginfoocio avatar Nov 13 '19 15:11 sginfoocio

Any solution? Thanks?

sginfoocio avatar Nov 18 '19 12:11 sginfoocio

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: [email protected]

JonathanMagnan avatar Nov 19 '19 20:11 JonathanMagnan

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: [email protected]

Looking forward to hearing from you,

Jon

JonathanMagnan avatar Nov 22 '19 13:11 JonathanMagnan

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: [email protected]

Best regards,

Jon

JonathanMagnan avatar Nov 29 '19 13:11 JonathanMagnan

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:[email protected] [email protected] http://www.sginfoocio.com/ www.sginfoocio.com

De: Jonathan Magnan [email protected] Enviado el: viernes, 29 de noviembre de 2019 14:29 Para: zzzprojects/EntityFramework-Extensions [email protected] CC: sginfoocio [email protected]; Mention [email protected] 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: [email protected] mailto:[email protected]

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

sginfoocio avatar Nov 29 '19 14:11 sginfoocio

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 avatar Nov 29 '19 14:11 JonathanMagnan

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

JonathanMagnan avatar Dec 13 '19 14:12 JonathanMagnan

Hi I send the poryect to [email protected].

Looking forward to hearing from you ;)

sginfoocio avatar Dec 13 '19 15:12 sginfoocio

Awesome @sginfoocio,

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

We will keep in touch :)

JonathanMagnan avatar Dec 13 '19 15:12 JonathanMagnan

Thanks,

sginfoocio avatar Dec 13 '19 16:12 sginfoocio