Devart Forums

vmakkenz wrote: ↑Thu 18 Nov 2021 10:46 I'm trying to do a simple linq query retrieving the building that contains a point

Code: Select all

        var point = new GeometryFactory().CreatePoint(new Coordinate(233569.922, 556664.502));
        var buildings = db.Building.Where(g => g.Geometry.Contains(point));

But I keep getting mapping errors

System.InvalidOperationException : Expression '@__point_0' in SQL tree does not have type mapping assigned.

Code: Select all

        var buildings = db.Building.Where(g => g.Geometry.Contains(new GeometryFactory().CreatePoint(new Coordinate(233569.922, 556664.502))));

System.InvalidOperationException : Expression 'POINT (233569.922 556664.502)' in SQL tree does not have type mapping assigned.

Using
DevArt 9.14.1369
.NET 5.0/6.0

• The bug with throwing the "Expression in SQL tree does not have type mapping assigned" error with NetTopologySuite in EF Core is fixed
• The bug with calling methods and properties of the Geometry class and its child classes, when the type member returns bool, with NetTopologySuite in EF Core is fixed

• The config.SpatialOptions settings are supported in EF Core
• The bug with throwing ORA-00920 by the GeometryCollection.Intersects method when using NetTopologySuite spatial service in EF Core 5 is fixed
• The bug with throwing ORA-00920 by the Geometry.Disjoint method when using NetTopologySuite spatial service in EF Core 3 and EF Core 5 is fixed
• The bug with throwing the "Unexpected primitive type kind 'r'." error when using NetTopologySuite spatial service with a geometric constant in EF Core 3 and EF Core 5 is fixed

Xor wrote: ↑Mon 20 Dec 2021 12:38 Since build agent are created each time build runs it can't use license.licx file and license installed on a system.

- task: CmdLine@2
  inputs:
    script: '$(Build.SourcesDirectory)\dcpostgresql.exe /TYPE=FULL /VERYSILENT'

floatingleaf wrote: ↑Tue 14 Dec 2021 14:30 Or would it be safer to expect it in Jan 2022?

msisco wrote: ↑Mon 13 Dec 2021 19:42 This got rid of the error regarding the ProviderManifest, but didn't solve the over-arching problem which I assumed was related.

If I try to "Update Model from Database" and select a connection, I am given the following error:

"Your project references the latest version of Entity Framework; however, an Entity Framework provider compatible with this version could not be found for your data connection."

I get the same error if I try to create a new model using dotConnect for MySQL.

hepek wrote: ↑Mon 13 Dec 2021 15:30 can you please provide that config entry with <publisherPolicy apply="no"/>?

<configuration>  
   <runtime>  
      <assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">  
         <dependentAssembly>  
            <assemblyIdentity name="Devart.Data"  
                                    publicKeyToken="09af7300eec23701"  
                                    culture="neutral" />
            <bindingRedirect oldVersion="0.0.0.0-5.0.2806.0" newVersion="5.0.2806.0"/>
            <publisherPolicy apply="no"/>  
         </dependentAssembly>
         <dependentAssembly>  
            <assemblyIdentity name="Devart.Data.Oracle"  
                                    publicKeyToken="09af7300eec23701"  
                                    culture="neutral" />
            <bindingRedirect oldVersion="0.0.0.0-9.14.1382.0" newVersion="9.14.1382.0"/>
            <publisherPolicy apply="no"/>  
         </dependentAssembly>
         <dependentAssembly>  
            <assemblyIdentity name="Devart.Data.Linq"  
                                    publicKeyToken="09af7300eec23701"  
                                    culture="neutral" />
            <bindingRedirect oldVersion="0.0.0.0-4.9.2351.0" newVersion="4.9.2351.0"/>
            <publisherPolicy apply="no"/>  
         </dependentAssembly>
         <dependentAssembly>  
            <assemblyIdentity name="Devart.Data.Oracle.Linq"  
                                    publicKeyToken="09af7300eec23701"  
                                    culture="neutral" />
            <bindingRedirect oldVersion="0.0.0.0-4.9.2351.0" newVersion="4.9.2351.0"/>
            <publisherPolicy apply="no"/>  
         </dependentAssembly>
      </assemblyBinding>  
   </runtime>  
</configuration>  

hepek wrote: ↑Mon 13 Dec 2021 15:30 btw - I don't thik I ever installed devart on this server.

hepek wrote: ↑Mon 13 Dec 2021 15:30 is there a way to tell devart NOT to use GAC?

hepek wrote: ↑Mon 13 Dec 2021 15:30 in another words - may I deploy the app in a way that it does not need devart installation at all.