Discussions tagged .NET DataStore

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 ...
I have noticed that DataObjectFactory.LoadDataWindow uses the App Domain's Base directory to find the pbwconfig file.  This will not work for us since we may have different DataWindow versions with the same name.  We need a way to dynamically set the...
I am getting the following error when attempting create a .net datastore in a deployed environment: Could not load file or assembly 'System.ComponentModel.Annotations, Version=4.1.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its ...
Using PB 2019, we have migrated several datastores to a SnapDevelop .NET assembly. Looking through the various tutorials and sample projects, we do not see any examples of accessing datastore column values using object dot notation. All appear to use...
Hi All, We are migrating a NVO to REST C# Web API. One of the methods that has to be migrated gets as argument a datastore and return, by reference, two (02) string arrays: column_names and dataTypes_names The PB method get the number of datastore ...
Hi all, We are evaluating the efforts to migrate PB NVOs from an EAS web app to REST API using Snap Develop and PB 2019. We already migrated few methods using the IDataStore object. However we noticed that several methods were missing from the orig...

Find Questions by Tag

.EXE .NET 6.0 .NET Assembly .NET Core 3.1 .NET Core Framework .NET DataStore .NET Std Framework 32-bit 64-bit ADO.NET AEM AI Algorithm Amazon AWS Android Apache API APK App Store App Store (Apple) Appeon Workspace Appeon Xcelerator Plug-in Architecture Array ASE Asynchronous Methods Authentication AutoBuild AutoCompiler Automated Testing Automation AutoScript Azure Barcode Base64 Batch BigData BLOB Branch & Merge Browser Bug Build Button C# C# Class Importer C# Editor C# Model generator Calendar Camera Certificate Chrome Citrix Class Client Client/Server Cloud Cluster Collection COM Command Line Compiler Compression Computed Field Configuration Controls Cookies Cordova Crash Cross-Platform Crosstab CSharpAssembly CSharpObject CSS CSV Cursor Data Database Database Driver Database Painter Database Profile Database Provider DataObject DataSource DataStore DataStore (C#) DataStore (PS) DataType DataWindow DATE DATETIME DB2 Debug Debugger Debugging Deployment Design DLL DO-WHILE Dockable Docker Documentation DOUBLE Download DragDrop Edge Edit Style Editor Elevate Conference Email Embedded SQL Emulator Encoding Encryption Enhancement Request Entity Entity Framework ERP Error Event Event Handler Event Handling Excel Exception Export Expression External Functions F# Field File File Access Filter Firefox Firewall Font FOR-NEXT Foreground Format Function Garbage Collection GeoLocation Git Graph HANA Hash Header HTML/5 HTTP/S HTTPClient Icon IDE Identity IIS IMAPI Import InfoMaker Inheritance Installation Integer IntelliSense Interface Internet Internet Explorer iOS IPA iPad iPhone IWA J# Java JavaScript JBoss JDBC JOIN JSON JSONGenerator JSONParser Kestrel Label Lambda Large File LDAP Library License LINQ Linux OS Load Balancing Localization Localized PBVM Log In Log Out Logging LONG LONGLONG macOS MAPI Maps MDI Memory Memory Leak Menu Merge MessageBox Messagging Method Migration MIME TYPE Mobile Model ModelStore ModelStore (C#) MSOLEDBSQL Multi Threading MVC MySQL n-Tier Namespace NativePDF NVO OAuth ODATA ODBC Office Offline OLE OLEDB Online Open Source OpenAPI OpenSSL Oracle OrcaScript Other Outlook Output Package Parameter Patch PayPal PB Classic PB Native PB.NET PBC PBD PBDOM PBG PBJVM PBL PBNI PBORCA PBVM PBX PDF Performance Permission PFC Picture Pipeline Play Store (Google) Plugin Popup Port POST PostgreSQL PowerBuilder PowerBuilder (Appeon) PowerBuilder (SAP) PowerBuilder Compiler PowerBuilder Runtime PowerClient PowerScript (PS) PowerScript IDE PowerScript Migrator PowerServer PowerServer Mobile PowerServer Toolkit PowerServer Web PowerServerLabel Print Properties Proxy Publish PULL PUSH Query Regression Release Renew Resize Response REST Retrieve RibbonBar RibbonBar Builder Rich Text Roadmap RPC Runtime Packager SaaS Scaffolding Script SDI SDK Security Server Service Session Single Sign-on Size SMTP SMTPClient SnapDevelop SOAP Sort Source Code Speech Recognition SQL SQL Anywhere SQL Server SqlBuilder SqlExecutor SQLite SqlModelMapper Storage Stored Procedure Subscription SVN Swagger Syntax TabbedBar TabbedView Tablet TabPage Target TE Control Testing Text TFS Theme TIME Timer TLS/SSL Tomcat TortoiseGit TortoiseSVN Transaction Transparency Trial Trigger TRY-CATCH TX Control Type UI ULONG UltraLite Uninstall Unit Test Unit Testing UNIX OS Update Upgrade Upload URL User Center User Object UWP Validation VARCHAR Variable Versioning Visual Studio Visual Studio Code VM Voice Warning WCF Web API Web Extensions Web Service WebBrowser WebForms WebLogic WebSphere WildFly WinAPI Window Windows OS WinForms Wizard Workgroup Workspace WPF XCODE XHTML XML Zoom