agracio / edge-js

Run .NET and Node.js code in-process on Windows, macOS, and Linux
MIT License
618 stars 93 forks source link

Trouble with using using Microsoft.Data.SqlClient #182

Closed Ormesome closed 4 months ago

Ormesome commented 1 year ago

Hi, it's been a long time since I've used c# and I'm trying to ease back in with a sort of database API using edge-js.

I have a repo at squirrel project where I am able to use System.Security.Cryptography successfully, but not Microsoft.Data.SqlClient.

I can make the database call (such as it is) using dotnet run from squirrel but when I dotnet publish then try to import it as a library either from squirrelConsumer or through edge-js from squirrelJs I get type errors. I'm hoping I've made a basic error that your eyes can spot.

agracio commented 4 months ago

Not sure if that is still an issue. Would strongly recommend using System.Data.SqlClient with Edge.js as Microsoft.Data.SqlClient behaviour is currently very erratic. What is the purpose of the library, there is edge-sql that supports variety of MS SQL statements.