Caching the Result from a [N Async] Factory Method Iff It Doesn't Throw

Error-Attempt by method 'X.set_DbConnection(System.Data.Common.DbConnection)' to access method 'Y.get_Settings()' failed

MySql.Data.Entity 6.10.7 isn't compatible with MySql.Data 8.0.11.

Oracle renamed the package to MySql.Data.EntityFramework for v8.x. You need to uninstall MySql.Data.Entity and install MySql.Data.EntityFramework.

MySql with asp.net have error

I suspect you're using MySql.Data v8.0.11 and MySql.Data.Entity v6.10.7. These have different major versions and are not compatible.

You need to uninstall MySql.Data.Entity and install MySql.Data.EntityFramework instead; Oracle changed the name as part of the upgrade to v8.x.

How to fix: The provider did not return a ProviderManifestToken string?

You appear to be using MySql.Data.Entity 6.10.7. I'm going to guess you're also using MySql.Data 8.0.11.

These two libraries are not compatible. Oracle renamed the package to MySql.Data.EntityFramework for v8.x. You need to uninstall MySql.Data.Entity and install MySql.Data.EntityFramework.

Find two consecutive rows

Assuming the rows have sequential IDs, something like this may be what you're looking for:

select top 1 * 
from 
Bills b1
inner join Bills b2 on b1.id = b2.id - 1
where
b1.IsEstimate = 1 and b2.IsEstimate = 1
order by
b1.BillDate desc

---

Related Topics