Bug #84352 Entity Framework Core - ExecuteSqlCommandAsync() hangs
| Submitted: | 28 Dec 2016 1:58 | Modified: | 16 Jan 2017 20:34 |
|---|---|---|---|
| Reporter: | Paito Anderson | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | Connector / NET | Severity: | S2 (Serious) |
| Version: | 7.0.6-IR31 | OS: | Any |
| Assigned to: | Gabriela Martinez Sanchez | CPU Architecture: | Any |
| Tags: | .Net Core, entity framework, Entity Framework Core | ||
[28 Dec 2016 1:58]
Paito Anderson
Sample App
Attachment: ConsoleApp1.zip (application/x-zip-compressed, text), 1.93 KiB.
[13 Jan 2017 22:53]
Gabriela Martinez Sanchez
I just try it using 6.10.0-alpha and EFCore 1.1. and works fine. Could you try using this other version? Please let us know if this worked. Thanks in advance.
[14 Jan 2017 14:56]
Paito Anderson
Hi Gabriela, You are correct 6.10.0-alpha works, but 7.0.6-IR31 does not work. Is 6.10.0-alpha actually the version people should be using with EF Core? Paito
[16 Jan 2017 17:38]
Gabriela Martinez Sanchez
For EF Core 1.1 yes, 6.10.x would be the one recommended. Eventually 7.0.x will be updated to have the latest support in EF Core but 6.10.x is a bit ahead. Can we close this bug then ?
[16 Jan 2017 20:34]
Paito Anderson
Closed, thanks for your help.
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.055 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the
respective copyright holders.
It is not reviewed in advance
by Oracle and does not necessarily represent the opinion of
Oracle or any other party.
Description: Hi, When using the async version of ExecuteSqlCommand(), called ExecuteSqlCommandAsync() the thread hangs and never returns to the application. The data does get inserted to the database however. Example: Works fine: Database.ExecuteSqlCommand("INSERT INTO TestTable (`DateTime`) VALUES (@utcDateTime);", parameters: new MySqlParameter("utcDateTime", MySqlDbType.DateTime) { Value = DateTime.UtcNow }); Thread Hangs: await Database.ExecuteSqlCommandAsync("INSERT INTO TestTable (`DateTime`) VALUES (@utcDateTime);", parameters: new MySqlParameter("utcDateTime", MySqlDbType.DateTime) { Value = DateTime.UtcNow }); Attached is a test console application that demonstrates the issue. MySQL Version used: 5.7.17 How to repeat: Try a INSERT statement using ExecuteSqlCommandAsync().