X# and .NET WebAPI - What is possible

This forum is meant for questions and discussions about the X# language and tools
Post Reply
Posts: 74
Joined: Sun Sep 20, 2020 7:25 am
Location: Germany

X# and .NET WebAPI - What is possible

Post by hilberg.it »


just checking what should be possible. What scenario is compatible. I was trying for the last days to add X# and ADS Db Connection to a .NET WebAPI project. Most of it worked, but unfortunately not every combination. So I want to know, what scenario should work and which one is not tested jet.

[*].NET 4.7.2 WebAPI + X# RT/RDD, AXDBFCDX + bTools.bServer -> works like charm! :cheer:
[*].NET 4.7.2 WebAPI + Advantage.Data.Provider, AdsConnection -> Collation Bug :angry:
[*].NET 5 WebAPI + X# RT/RDD, AXDBFCDX + bTools.bServer -> not possible?
[*].NET 5 WebAPI + Advantage.Data.Provider, AdsConnection -> Collation Bug

The thing is, that I wanted to use .NET 5 together with ADS as my WebAPI. But I could not get everything to work properly.
  • Is X# and bTools.bServer compatible with .NET 5 at all? X# propably yes, but what about bDbServer?
So I went for .NET 4.7.2 which seems to work fine with X# RDD, AXDBFCDX and bTools.bServer. Unfortunately I have a collation issue with ADS configured in collation=OEM and AdsConnection, AdsCommand approach. I set CharType=OEM in the connection string, but that didn't do it. But if I encapsulate the query in a subquery, umlauts get transferred correct. That looks pretty weird to me. I don't know where this problem could be located. It definitely has nothing to do with X#. Rather with Advantage.Data.Provider.dll.
  • Any ideas how to treat the collation issue?
  • And finally, in which scenario is Advantage.EntityFramework possible? .NET 4.7.2? Didn't get this to work either.
Thank you very much.
User avatar
Posts: 4264
Joined: Fri Aug 21, 2015 10:57 am
Location: Netherlands

X# and .NET WebAPI - What is possible

Post by robert »

For now we do not support .Net 5 and beyond.
The compiler is ready for this but our VS integration and build system needs some extra work.
Most of the runtime should work unchanged with .Net 4 and beyond.
I do not know if the advantage data provider is .Net 5 compatible. The ADS RDDs in X# use the Win32 layer and that should work just like the .Net Framework version.
For support on the Advantage Data Provider I would recommend contacting SAP support.

XSharp Development Team
The Netherlands
Post Reply