Do you have any working example of using SQLite database?
Solved: I created new set of custom activities to work with SQLite (connection, Execute Query/NonQuery/Insert…). Can be closed.
Did standard db activities not work?
One would think they should…
@andrzej.kniola standard Database Connect activity has < ProviderName > as required parameter. Installing a provider for SQLite on the machine running the robot defeats the purpose of having the database “embedded” within the workflow. I selected SQLite based on several criteria, database being “embedded” is one of them among but not all: persistent storage (NOT in memory), ability to use SQL or similar DML, price.
But again, since I am still learning, if you have a working example for using SQLite please let me know / send me the link to it.
I have found this very useful: https://docs.microsoft.com/en-us/dotnet/framework/windows-workflow-foundation/samples/property-grid-extensibliity
And of course the tutorials
Custom Activity: Collection as Input Argument
Would you be willing to share your code for the custom activities? I am also trying to connect uipath to a local SQLite .db, for persistent storage.
Hi @Tiramisu Unfortunately I cannot do this since I work for a company and they own all IP for my work. I will however help you build something similar, just ask the questions.
But if it is only for persistent storage (e.g. no DML over data) I highly recommend to consider .xlsx files.
That’s very kind of you. I am working though this guide
but if I would run into problems then I will surely return here.
So update. I have a simple but functional SQLite nuget package for use in UiPath. I don’t know when I will get around to upload it but if anyone is urgently in need I will hurry up. I can share source code and .nupkg package as well.