Using an in-memory SQLite database possible?

[Gerik]

Hello,

I would like to use SQLite as an in-memory database with NinjaTrader. Would that be possible somehow?

With

using.Microsoft.Data.SQLite;

I get an error that Microsoft is not in the namespace contained (missing assembly link).

How can I use an in-memory database?

Sincerely
Gerik

[NinjaTrader_ChrisL]

Hello, thanks for writing in. Using a database like this is not supported, so I will not be able to test it out, unfortunately. Make sure you have the DLL referenced to this Microsoft.Data.SQLite path. Right click the script editor>References, then add the reference to the correct DLL file that contains this class.

[Gerik]

Hello Chris,

thank you. I could include the reference.

However, I am struggling with connecting to an sql database that I have already created. Is there any sample code snipped as an example with NinjaScript somewhere available?

Has anyone tried to use sqlite within NinjaScript?

Sincerely
Gerik

[NinjaTrader_ChrisL]

Hi Gerik, unfortunately, this goes outside of the scope of support I am able to provide on the subject.

[bltdavid]

Google is your friend.

Good reading here.