Creating Custom Activity via NugetPackge which also uses a NugetPakage itself

[Muhammad_Umair_Malik]

Hi everyone,
Hope you all are doing well. I’m new to RPA
I’m using UiPath community version(not legacy) and dotnet 6.0
I’m trying to create a CustomActivity to perform Sqlite Database operations. My Class Library is using nuget package System.Data.Sqlite , I’ve created the package successfully, also tested it with a simple c# console project(which is working fine)
when I add my package to UiPath and try to run the activity, it is throwing error as below

My Solution Explorer is like this

I was also getting error previously ‘Could not load file or assembly System.Data.Sqlite’ , so I added System.Data.Sqlite.dll as well in the nuget package as below

Kindly correct me if I’m doing anything wrong
Thanks in advance.

[Anil_G (Anil Gorthi)]

@Muhammad_Umair_Malik

Can you please cross verify here …i fyou followed properly

Activity Creator with .NET 6 Support is now released

A new version of the Activity Creator, the Visual Studio extension that generates custom activity code, has been released! The latest version works in Visual Studio 2022 and generates activities compatible with .NET 6-windows so you can upgrade all of your .NET Framework activities to a modern version of .NET. See here for more details, dependencies, and tutorials. Breaking Changes: You will now need a new feed added to your Nuget package sources in order to pull in the extension’s required…

Cheers

[Jon_Smith]

Do the existing database activities from UiPath not cover your use case? I do not think you need to make custom activities.

[Muhammad_Umair_Malik]

Thanks @Anil_G ,
Actually I used the old method i.e., creating class library c# project, and make package using Nuget Package Explorer
I followed this link to create package.

Migrating Activities to .NET 6

Also, If a do not use System.Data.Sqlite in my custom activity then everything goes fine.

[Muhammad_Umair_Malik]

Thank @Jon_Smith ,
yes I first tried to use built-in activities but found hard to make it dynamic as I wanted to only pass the connection string to dynamically connect to my Sqlite Database
Therefore I preferred to create Custom Activity
Also my custom activity works fine when I do not include any third party nuget package in it.

[Jon_Smith]

The Database activities have a connection string object you can create dynamically?
What part did you struggle with?

[Muhammad_Umair_Malik]

It also has a required parameter named “Provider name”
I do not know how to handle it to make it dynamic

[Jon_Smith]

Hahaha, that is much easier than creating a custom activity!

Maybe make a new topic and ask that?

[Muhammad_Umair_Malik]

Sure, Thanks for your reply

[Jacqui_M (Jacqui Muller (MEA))]

Hey @Muhammad_Umair_Malik, could this be because your connection string is “hello world”?

[Muhammad_Umair_Malik]

Thanks @Jacqui_M,
I wish it would be , but it’s not the issue, I tried with passing the right connection string.
Also in case of wrong connection string, SQLite throws proper relevant exception (I tried that too)

[Muhammad_Umair_Malik]

I found the problem,
Actually my Custom Activity project was building on x64 bit target platform, but the third-party sqlite library which I was using was for 32bit applications
This was the main issue, so I first download a 64bit System.Data.Sqlite.dll file(you can find it easily from dllme)
Then I created a nuget Package for that 64bit dll, and add it into my project as well as in UiPath dependencies
So that I don’t have to include System.Data.Sqlite in my own package.
Now it’s working fine
Thanks to @all .