How to access SqLite database from an indicator

[ramckay]

I've been accessing an .sdf database from an indicator. The .sdf format is getting a bit long in the tooth so I'm transitioning to SqLite, or trying. I'm very new to SqLite. I've successfully created and updated databases using both sqlite3 and SQLite-net-pcl. This has been accomplished in Visual Studio 2022. When I try to copy the code into a NinjaTrader indicator script with a 'using SQLite;' statement I get errors. I have copied the reference files into ...\custom\bin folder. I've also tried using sqlite3 which also causes errors. The question here is which libraries do I need to use to access .sqlite databases and where do I find them?
Thanks in advance.

[NinjaTrader_ChelseaB]

Hello ramckay,

Accessing the NinjaTrader Database is not supported by NinjaTrader.

This thread will remain open for any community members that would like to assist.

I am also including a link to a google search you may find helpful.

https://www.google.com/search?q=site%3Aninjatrader.com+sqlite

[ramckay]

Thanks Chelsea, I posted this question after spending a week and a half searching for answers. SqLite has been mentioned a couple of times in forum posts but the specific details have not been discussed. I've seen a few questions about SqLite and thought a post would give anyone interested a place of reference. I did get NT to load a database using System.Data.Sqlite ver 117. I'm not trying to find how to get LINQ to work. Thanks for all the great help.