Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1

TOPIC:

X# and .NET WebAPI - What is possible 27 Jun 2022 10:55 #22901

  • hilberg.it
  • hilberg.it's Avatar
  • Topic Author


  • Posts: 57
  • Hi,

    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.
    1. .NET 4.7.2 WebAPI + X# RT/RDD, AXDBFCDX + bTools.bServer -> works like charm! :cheer:
    2. .NET 4.7.2 WebAPI + Advantage.Data.Provider, AdsConnection -> Collation Bug :angry:
    3. .NET 5 WebAPI + X# RT/RDD, AXDBFCDX + bTools.bServer -> not possible?
    4. .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.

    Please Log in or Create an account to join the conversation.

    Last edit: by hilberg.it.

    X# and .NET WebAPI - What is possible 27 Jun 2022 12:30 #22903

    • robert
    • robert's Avatar


  • Posts: 2974
  • 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.

    Robert
    XSharp Development Team
    The Netherlands

    Please Log in or Create an account to join the conversation.

    • Page:
    • 1