SQL Server Database

[siroki]

Hi,

I'm building a script that exports to a SQL Server database. But for some reason I cannot do:

using System.Data.SqlClient;

Does NT not support it?

[NinjaTrader_JC]

Hello siroki,

We do not support this but you should be able to do it with custom code. Do you know what .NET version of your SQL that you are using?

NinjaTrader will only be able to use .NET 3.5 and below versions.

[siroki]

I'm using the latest .NET version and Visual Studio 2012 and SQL Server 2012. Im trying to program it with a custom script. Can you point me in the right direction? Maybe using System.Data.SqlClient was not available in .NET 3.5?

[NinjaTrader_JC]

Hello siroki,

Looking at MSDN's website it looks like this is available from .NET 1.1 to 4.5

http://msdn.microsoft.com/en-us/library/System.Data.SqlClient(v=vs.90).aspx

What errors are you having? Do when you compile the script inside of NinjaTrader do you get an error?

[siroki]

When I type in > using System." the intellisense doesn't show Data. So I think for some reason it's not in the System collection available.

When I just type it in (using System.Data / using System.Data.SqlClient) it gives an error "The type or namespace Data does not exist in the namespace System.. Which is correct because I already saw that through Intellisense..

For what it's worth. I've just created a project in Visual Studio and get no errors there...

I've checked RegEdit and all the proper .net versions are installed including 3.5 and 4.0.. I'm running Windows 8.1

[siroki]

I think I've located the issue. I needed to Add Reference to System.Data (right click in the script, add reference). Seems to be working now.

[NinjaTrader_JC]

Hello siroki,

Thanks for the update.

Any new Namespaces that you add you will want to make sure that you have the assembly that goes with them. By Default NinjaTrader only references, System, System.Core, System.Drawing, System.Windows.Forums, and System.XML so any other namespaces defined in other assemblies you will have to reference them as well.