How to implement SQLCA in C#

[chris_keating]

I have a question about SQLCA in Ultra Lite17.

When I refer to Ultra Lite's HELP, I see the phrase SQLCA, but I don't know how to implement it in C#. Referenced URL: https://dcx.sap.com/index.html#sqla170/ja/html/3bd645d06c5f10149435f7046055716b.html https://help.sap.com/docs/SAP_SQL_Anywhere/98ad9ec940e2465695685d98e308dff5/3bd645d06c5f10149435f704...

The above address only describes how to implement it in C++. Could you please let me know if there is a way to implement it in C#?

[chris_keating]

SQLCA is an embedded SQL structure. It would not generally be used in a C# application - and if so, it would need to be implemented in unmanaged code.

You can think of ULConnection as loosely related to SQLCA. If you application requires multithreaded access to the database, each thread should have a separate ULConnection instance (connection). An error will be reported if more than one thread tries to concurrently access the database from the same connection.

UltraLite Embedded SQL

Connection Setup for an UltraLite Database

[miyata_k]

Thank you for your quick response. I will consider implementing it with unmanaged code. If you have any implementation examples or sample code using unmanaged code, I would appreciate it if you could let me know.

[chris_keating]

Adding unmanaged code is likely an unnecessary complexity since there is little, if anything, that can only be achieved in embedded SQL. Perhaps we can provide guidance on implementation in UL.NET.

If you need to use embedded SQL that you are calling from .NET, refer to:

Consuming Unmanaged DLL Functions