Discussions tagged .NET DataStore

I am having an interesting problem writing a .NET Core 3.1 API using SnapObjects to connect to SQL Anywhere via ODBC.  The problem has to do with when database connections are made and released.  The SQL Anywhere database I am using has long been in...
Hello,I'm following the tutorial: https://docs.appeon.com/dwconverter2019r3/CRUD_Operations_with_.NET_DataStore/index.html But when I call the Create method from PowerBuilder 2019 R3 I get the following error message: "JSON value could not be conver...
Hello, I started to work in PowerBuilder 2019 R3 working on the example https://docs.appeon.com/dwconverter2019r3/CRUD_Operations_with_.NET_DataStore/index.html#introduction CRUD Operations with .NET DataStore, I did all step until the test the Retr...
I have generated C# Models (POCO objects) from DataWindows which I use in a SnapDevelop Web API project.  I am wondering what the best practice is to use these POCO objects in my Xamarin .NET mobile app client project.  They are needed in the client ...
Dear All, When I am trying create a REST API based on below video, exactly I am following, when I link my API,  Getting error like below : fetch cors header ‘access-control-allow-origin’ missing................. Any one can advise, how to resolve ...
Hi, I understand that we can open a SnapDevelop project in Visual Studio. Is there a PowerBuilder licence needed on a PC with Visual Studio using project with .NET DataStore? Thanks,Marcin...
Dear Team,   Could u give some advice about how to convert the datastore to .net, we have migrated our service from ESA to .net Web Service. Part of functions in service using the data store to get or set item. Another question is if the Web Serv...
Hello, is there a way to influence the binding process between SnapObjects and a database (specifically Oracle) yet? The issue we're facing is that when reading from an Column that has the type NUMBER, SnapObjects requires the property in the C# Mo...
I read docs for DWnet.Data but not see nothing like getfullstate & setfullstate who use blob. has anyone had a similar problem and found a solution....
Hi, We plan to deploy .NET assemblies with .NET Datastores in the near future. The datastores were created using PB 2019 R2 build 2328, if that is relevant. Does Appeon recommend any obfuscation tools? If not, has anyone had experience with such ut...
Hi, Is there a documented list of runtime files required to support .NET assemblies containing .NET Datastore code? We have identified some of these (below). DWNet.Data.dllSnapObjects.Data.dllSnapObjects.Data.Odbc.dllSnapObjects.Data.SqlServer.dllS...
How do you do a sort off of multiple fields? The SortBy for a C# DataStore only seems to accept one key field. Thanks,Bernie...
Hi support team, I am following below article and tried to generate a grid type DW into C# model, but could not find where is the "Generate C# Model" option. https://docs.appeon.com/appeon_online_help/powerbuilder/CRUD_Operations_with_.NET_DataStor...
Hi everyone,  I ran into a problem while trying SnapDevelop. I am trying to create simple REST API.   I have a DataStore, which is imported from PB. It uses stored procedure as a data source. That stored procedure takes 5 arguments.  I can create...
Hi, I would like to know what are the options below the function DataStore.Retrieve(arg[]) method, can I use any passing argument to get only the first 50 values ? Regards, ...
Hi all, the .NET Datastore only has a couple of events, namely RetrieveStart, RetrieveEnd, UpdateStart, UpdateEnd, RowDeleting, RowDeleted. There does not seem to be an event "SqlPreview". In PowerBuilder one can see the issued SQL of every single ...
My understanding of the DynamicModel structure is that it is a way to generate a dynamic datastore from SQL, similar to executing these statements: new_syntax = SQLCA.SyntaxFromSQL(new_sql, 'Style(Type=Form)', error_syntaxfromSQL) dw_new.Create(new...
I see that you use ILogger to capture errors in some of you PowerBuilder.Data objects.  I have a couple of questions.  I am not sure how to use this method other than the method you show in one of your examples. var factory = new LoggerFactory(); fa...
Is there a way to place in the cache the IReadOnlyDataObject created by DataObjectFactory.ParseDataObject so it can be available for instantiating a DataStore object? As far as I can tell from the documentation, instantiating a DataStore depends on ...
Problem: Any value I pass to the Retrieve(argument) method returns the error below. I can't tell why. I've tried different data types in the database I need to pull records from. I've tried to use Guids, strings, number types, etc, but none of them ...
  • Page :
  • 1