Namespace Does Not Exist

[kezyclaire]

Hi,

I installed a new packages in Visual Studio Editor, I dont see an error while compiling in Visual Studio but I get an error when I compile it in NinjaScript Editor. How do I add the new packages into my NinjaScript NameSpace so it will recognize it when compiling.

I am trying to connect to my local Database using MS SQL Server, that is possible right?

Thanks.

[bltdavid]

Have you added the appropriate references to the
MS SQL Server assemblies to NinjaTrader?

See 'Adding a reference' here.

[kezyclaire]

Hi bltdavid

I was able to add the reference and now compiling successfully. The problem now is I am not able to connect successfully to my local database. Do you have any sample code or reference on how to connect to a SQL database to access data?

Thanks.

[NinjaTrader_BrandonH]

Hello keyzclaire,

Thanks for your notes.

Connecting to a local SQL database would go beyond the support NinjaTrader's Support team would be able to provide you with.

This forum thread will be open for other community members to share their insight on the topic.

You could also consider researching the topic by doing Google searches such as 'How to connect to local SQL database C#' to find more information.

[bltdavid]

Do you have any sample code or reference on how to connect to a SQL database to access data?

Sorry, I do not.

Google is your friend.

[kezyclaire]

bltdavid, yeah, I am trying to use Dapper. It works using Windows Application App but not working when connecting with NinjaScript

[bltdavid]

Not working how?
What error messages are you getting?

Do you have a non-NinjaScript C# code example
successfully connecting to this same database?

[bltdavid]

Does Dapper work with .NET Framework 4.8.1?

Did you download the correct .NET version of Dapper?

[kezyclaire]

bltdavid

Here is the error message. I have attached 2 screenshots, Windows Application Form is returning 3 rows while when running Ninja Script, it is already returning error when calling GetBarsPer in Class DataAccess. I am using the same statement, Database connection and Table in DataAccess Class, I just copy and paste. They are all the same from initializing and calling.

Dapper statement
result = connection.Query<BarsPeriodModel>("Select * From BarsPeriod Where Value = 0").ToList();

$exception

{"Could not load file or assembly 'Dapper, Version=2.0.0.0, Culture=neutral, PublicKeyToken=null' or one of its dependencies. The system cannot find the file specified.":"Dapper, Version=2.0.0.0, Culture=neutral, PublicKeyToken=null"} System.IO.FileNotFoundException

◢

[bltdavid]

Where is your 'Dapper.dll' file located?

[kezyclaire]

bltdavid I put in bin folder where ninjatrader was installed.

[bltdavid]

I think it should be located here,
C:\Users\<username>\Documents\NinjaTrader 8\bin\Custom

Ask NT Support where it should go ...

[kezyclaire]

bltdavid I tried to read the log, it looks like it is looking for other dll, and then when I add the dll, other errors were occurring. Mostly about version errors. I think it is better to not be using dapper and other add ons and I will just go with simple sql connection. Thanks for your time ☺️