Missing Assembly reference

[Mark]

Hi

 

I am trying to run a SQL Stored Procedure using a Coded Step in Test Studio and when do so getting following error

The type or namespace name 'Data' does not exist in the namespace 'System' (are you missing an assembly reference?)

Can anyone advise on how i can fix this at all?

I have the following set in the Coded Step

using System.Data;

using System.Data.SqlClient;

Many Thanks

 

 

[Elena]

Hi Mark, 

What references you have added in the project? Can you share a screenshot of these? 

Regards,
Elena

[Mark]

Hi Elena

Have attached some screenshots for you

 

 

[Elena]

Hello Mark,

Based on the additional details shared it seems that you don't have added a reference in the project to the System.Data.dll. This is what the compilation error message states. The requirement is also listed in the coded example on how to connect to SQL DB listed in Test Studio documentation. 

So, in order to compile the code you will need the external reference to the System.Data.dll inserted within the project settings.

Regards,
Elena
Progress Telerik

[Mark]

Hi Elena

Thanks for this. Have added this now from

C:\Windows\Microsoft.NET\assembly\GAC_64\System.Data\v4.0_4.0.0.0__b77a5c561934e089