DevArt | It provides many utils | iOS library

I am developing an open source class library (MySqlBackup.NET) which it can works with 3 optional dependencies that are developed by different developers, but they all have the same namespace type MySqlCommand.

• MySQL.DATA.dll
• Devart.Data.MySql.dll
• MySqlConnector.dll

Each time I released a nuget package, I need to compile 3 times separately with it's specific dependencies.

Is there a way to compile the library that works without needing to bind (locking) the specific target dependency? That it will work if any of the dependant dll that contains the required namespace type exists.

And also, each time when the dependencies had released a new version, I need to recompile again just to match the version number of the dependencies and re-submit new nuget package, but there is actually no code change within my class library.

How to compile the class library that will ignore the version number of the dependencies?

...

Premise We have an application in .NET 4.7.2 using Entity Framework 6 db-first (with an `.edmx` file). Until now we have used only Devart for Oracle as Provider for EF, but now we need to handle SQL Server databases. All our ASP.NET MVC 5 views (hundreds) need to work with `System.Data.SqlClient`. No problem, query works well except for... Issue The issue is related to foreign key and referenced table.

The error is the following:

InvalidOperationException: the cast to value type 'System.Int32' failed because the materialized value is null. Either the result type's generic parameter or the query must use a nullable type.

at System.Data.Entity.Core.Common.Internal.Materialization.ErrorHandlingValueReader1.GetValue(DbDataReader reader, Int32 ordinal) +177 at lambda_method(Closure , Shaper ) +1146 at System.Data.Entity.Core.Common.Internal.Materialization.Coordinator1.ReadNextElement(Shaper shaper) +384
at System.Data.Entity.Core.Common.Internal.Materialization.SimpleEnumerator.MoveNext() +88
at System.Linq.Buffer1..ctor(IEnumerable1 source) +284
at System.Linq.Enumerable.ToArray(IEnumerable`1 source) +90
at Medici.MediciService.GetMedici(GetMediciQuery param)

The query example:

...

We have several microservices built on top of aspnetcore and entity framework and using the MySQL EntityFramework connector from Devart. I've noticed that if the first query that any of our applications attempts fails due to the data store being inaccessible, then the failure seems to be cached, and when the DB is finally alive, the exception is still returned to the user code.

As part of the diagnosis of this problem I tried disabling the database when the application is running and in this situation the application appears to be able to recover once the DB is available again, so I suspect the problem is related to a connection that may be cached during model initialisation.

I've also tried disabling the service provider caching and this also lets the application recover but at the cost of having to initialise the service provider each time, so this can't be used in our application but lends weight to the idea that the error is related to some form of caching.

Has anyone else had/seen this problem before? What was your solution?

Here is a stack trace for context:

...

I have two schemas Bob and Bill. I want to scaffold with schema Bob all tables and with schema Bill only View_Otf table.

If I use the following code, I get an empty DbContext:

...

I'm using the library Devart.Data.PostgreSql (https://www.nuget.org/packages/Devart.Data.PostgreSql/) to interact with PostgreSQL from a C# application, but I run into problems when I try to connect to a PostgreSQL instance hosted in Azure that enforces TLS 1.2. From what I understand there is a problem with ciphers not being able to match during the handshake as I end up with this exception:

...

I'm following this guide to convert columns to rows in T-SQL: https://blog.devart.com/is-unpivot-the-best-way-for-converting-columns-into-rows.html

However, I need to convert only if one of the columns is set to 1.

Table:

...

The Update-Database -script command generates an incomplete sql.

The weird behavior is that the missing output from sql is dumped in the Package Manager console.

Example migration:

...

I just got into a Asp.NET web-project and I'm trying to setup the application. When I run the application and call an endpoint on localhost I get the error "InvalidOperationException: Unknown connection string parameter 'SSLMode'".

Here is the full stacktrace:

...

I'm using Devart with Oracle database 10g and Entity Framework Core 5 and I'm trying to create the models from database with Scaffold-DbContext:

...