\'System.IO.FileNotFoundException\' in Eco.Persistence.SqlServer.dll

[SteveAParticipant]

Greetings

I encountered a FileNotFoundException exception
Could not load System.Data.SqlServerCe
This occurred when trying to save a BtyeArray

The problem goes away if System.Data.SqlServerCe is added to the project.
System.Data.SqlServerCe is not part of any Mdriven nuget package.
There is no warning at compile time just an exception at runtime.

Regards Steve

• This topic was modified 5 years, 10 months ago by  SteveA.
• This topic was modified 5 years, 10 months ago by  SteveA.

Attachments:

You must be logged in to view attached files.

[AdminKeymaster]

This is a side effect of the SQLServer mapper doubling down as as SQLServerCompact as well.

Compact database needed special treatment of parameters

  public class SqlCeHelper
  {
    public static void SetSqlDbTypeOnParam(IDataParameter parameter, SqlDbType dbtype)
    {
      if (parameter is SqlParameter)
        ((SqlParameter)parameter).SqlDbType = dbtype;
      else if (parameter is System.Data.SqlServerCe.SqlCeParameter)
        ((System.Data.SqlServerCe.SqlCeParameter)parameter).SqlDbType = dbtype;

    }
  }

for all these types in the enclosed image

Attachments:

You must be logged in to view attached files.

[SteveAParticipant]

Sorry, but I don’t understand. I’m not using SQLServerCompact, but for some reason it appears to be required when trying to save a ByteArray SqlServer Standard Edition.
regards Steve

[AdminKeymaster]

For now you will need to reference and include the the System.Data.SqlServerCe assembly in your SqlServer using app.

But I will check in an update to remove this need today.
I found that JIT-compile of method SetSqlDbTypeOnParam failed when it referenced the ce-param type and the ce assembly was not loaded. Just moving the check to a separate method only called if the normal non-ce param check fails solved the issue.

[Author]

Posts