• You are here:  
  • Home
  • Q&A
  • Q&A
  • .NET DataStore
  • Web API transaction management and multiple DWs update in single transaction.

Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (3)

Resolved Web API transaction management and multiple DWs update in single transaction.

  1. How-to
0
Votes
Undo
  1. Miraben Apani
    Miraben Apani
  2. .NET DataStore
  3. Tuesday, 24 January 2023 20:39 PM UTC

Hi,

I have converted two Datawindows into C# using Snap Develop, have two .NET Datastores, created a WEB API(c#) .I am using ODBC data connection. Working on Transaction management at API side, how to pass multiple DWs from PB (Client side) to API side. If I have dw_1 and dw_2, on ue_savechanges() event, which will accept changes from both DWs at PB side , how to bundle the changes and send it over to WEB API in single transaction?

Thanks,

 

  1. Transaction
  2. Web API
.Net DataStore support for Updating SQL Server Vie...
What is the solution to use .net datastore saveas ...
Responses (3)
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Tuesday, 24 January 2023 21:00 PM UTC
  2. .NET DataStore
  3. # 1

Hi Miraben ;

  For that "use case", you would use the JSONPackage Object class ...

FYI:  https://docs.appeon.com/pb2019/objects_and_controls/ch02s45.html

HTH

Regards ... Chris

 

Comment
There are no comments made yet.
Logan Liu @Appeon
Logan Liu @Appeon Accepted Answer Pending Moderation
  1. Wednesday, 25 January 2023 02:40 AM UTC
  2. .NET DataStore
  3. # 2

Hi Miraben,

Except for the JSONPackage on the Client side, you can use IDataPacker.GetDataStore method to help you to get two .NET DataStores from the JSON on the Web API side: https://docs.appeon.com/net_datastore/4.x/api_reference/DWNet.Data/DataStore/DataStorePackerExtensions/Method/GetDataStore3.html

There was a similar post about this question: https://community.appeon.com/index.php/qna/q-a/process-jsonpackage-in-snapdevelop-controller

For how to Work with Transactions in .NET DataStore, please refer to: https://docs.appeon.com/dwconverter2022/Working_with_Transactions_in_.NET_DataStore/index.html#transactions-using-datacontext-transaction-apis

Regards, Logan

Comment
There are no comments made yet.
Miraben Apani
Miraben Apani Accepted Answer Pending Moderation
  1. Monday, 6 February 2023 14:27 PM UTC
  2. .NET DataStore
  3. # 3

Thanks for all responses.

At PB side, I am able to get two DWs with modified data in ls_json using JSON Package, at API side I am using DataPacker and DataUnpacker, tried using Update() and SaveChanges() for transaction management - unable to Save changes in database.

When I debug the code both Datastores which I am using with Data packer/unpacker both became empty. 

Any suggestion on "how to" at API side, so that data gets saved in database successfully?

Comment
Logan Liu @Appeon
  1. Logan Liu @Appeon
  2. Tuesday, 7 February 2023 01:44 AM UTC
I will reply to your new post at: https://community.appeon.com/index.php/qna/q-a/web-api-transaction-management-and-multiple-dws-update-save-changes-in-single-transaction
  1. Helpful
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.