C# Class wont allow SQL directive
I have created a class to make my code more maintainable, as having it in a class with methods will reduce the size of my code by a fair bit.
However, When I try and use the SQL directive I receive an error:
"type or namespace name could not be found”
The target framework currently being used if .NET standard 2.0, I have tried to change it via the properties, however, the only versions available are 1.9 - 1.0.
My main project is using .NET framework 4.6.1 - Will having the same frameworks make a difference? Strange that I can not modify the class target framework easily...
I have done the following as well:
Right Click on Project > Manage Nuget Packages > Search & install 'System.Data.SqlClient'
I continue to receive a 'directive is unnecessary error'
(Start of code:
using System.Data.SqlTypes;
namespace Game
{
public class Choice
{
//public SqlConnection Test;
public sqlConnection Test;
}
)
How can I connect use the System.Data.SqlTypes directive?
c#
edited Nov 11 at 5:52
D-Shih
25.3k61431
asked Nov 11 at 5:48
NodeCode
205
add a comment |
I have created a class to make my code more maintainable, as having it in a class with methods will reduce the size of my code by a fair bit.
However, When I try and use the SQL directive I receive an error:
"type or namespace name could not be found”
The target framework currently being used if .NET standard 2.0, I have tried to change it via the properties, however, the only versions available are 1.9 - 1.0.
My main project is using .NET framework 4.6.1 - Will having the same frameworks make a difference? Strange that I can not modify the class target framework easily...
I have done the following as well:
Right Click on Project > Manage Nuget Packages > Search & install 'System.Data.SqlClient'
I continue to receive a 'directive is unnecessary error'
(Start of code:
using System.Data.SqlTypes;
namespace Game
{
public class Choice
{
//public SqlConnection Test;
public sqlConnection Test;
}
)
How can I connect use the System.Data.SqlTypes directive?
c#
edited Nov 11 at 5:52
D-Shih
25.3k61431
asked Nov 11 at 5:48
NodeCode
205
What did you want to achieve?
– D-Shih
Nov 11 at 5:52
do you haveSystem.Data.dlladded to your project references?
– styx
Nov 11 at 5:52
replaceusing System.Data.SqlTypes;withusing System.Data.SqlClient;
– Prix
Nov 11 at 6:01
add a comment |
I have created a class to make my code more maintainable, as having it in a class with methods will reduce the size of my code by a fair bit.
However, When I try and use the SQL directive I receive an error:
"type or namespace name could not be found”
The target framework currently being used if .NET standard 2.0, I have tried to change it via the properties, however, the only versions available are 1.9 - 1.0.
My main project is using .NET framework 4.6.1 - Will having the same frameworks make a difference? Strange that I can not modify the class target framework easily...
I have done the following as well:
Right Click on Project > Manage Nuget Packages > Search & install 'System.Data.SqlClient'
I continue to receive a 'directive is unnecessary error'
(Start of code:
using System.Data.SqlTypes;
namespace Game
{
public class Choice
{
//public SqlConnection Test;
public sqlConnection Test;
}
)
How can I connect use the System.Data.SqlTypes directive?
c#
edited Nov 11 at 5:52
D-Shih
25.3k61431
asked Nov 11 at 5:48
NodeCode
205
I have created a class to make my code more maintainable, as having it in a class with methods will reduce the size of my code by a fair bit.
However, When I try and use the SQL directive I receive an error:
"type or namespace name could not be found”
The target framework currently being used if .NET standard 2.0, I have tried to change it via the properties, however, the only versions available are 1.9 - 1.0.
My main project is using .NET framework 4.6.1 - Will having the same frameworks make a difference? Strange that I can not modify the class target framework easily...
I have done the following as well:
Right Click on Project > Manage Nuget Packages > Search & install 'System.Data.SqlClient'
I continue to receive a 'directive is unnecessary error'
(Start of code:
using System.Data.SqlTypes;
namespace Game
{
public class Choice
{
//public SqlConnection Test;
public sqlConnection Test;
}
)
How can I connect use the System.Data.SqlTypes directive?
c#
c#
edited Nov 11 at 5:52
D-Shih
25.3k61431
asked Nov 11 at 5:48
NodeCode
205
edited Nov 11 at 5:52
D-Shih
25.3k61431
asked Nov 11 at 5:48
NodeCode
205
edited Nov 11 at 5:52
D-Shih
25.3k61431
edited Nov 11 at 5:52
D-Shih
25.3k61431
edited Nov 11 at 5:52
D-Shih
25.3k61431
25.3k61431
asked Nov 11 at 5:48
NodeCode
205
asked Nov 11 at 5:48
NodeCode
205
asked Nov 11 at 5:48
NodeCode
205
205
What did you want to achieve?
– D-Shih
Nov 11 at 5:52
do you haveSystem.Data.dlladded to your project references?
– styx
Nov 11 at 5:52
replaceusing System.Data.SqlTypes;withusing System.Data.SqlClient;
– Prix
Nov 11 at 6:01
add a comment |
What did you want to achieve?
– D-Shih
Nov 11 at 5:52
do you haveSystem.Data.dlladded to your project references?
– styx
Nov 11 at 5:52
replaceusing System.Data.SqlTypes;withusing System.Data.SqlClient;
– Prix
Nov 11 at 6:01
What did you want to achieve?
– D-Shih
Nov 11 at 5:52
What did you want to achieve?
– D-Shih
Nov 11 at 5:52
do you have
System.Data.dll added to your project references?– styx
Nov 11 at 5:52
do you have
System.Data.dll added to your project references?– styx
Nov 11 at 5:52
replace
using System.Data.SqlTypes; with using System.Data.SqlClient;– Prix
Nov 11 at 6:01
replace
using System.Data.SqlTypes; with using System.Data.SqlClient;– Prix
Nov 11 at 6:01
add a comment |
1 Answer
1
active
oldest
votes
You are using the wrong namespace here.
Instead of:
using System.Data.SqlTypes;
You should use SqlClient and I recommend also System.Data:
using System.Data.SqlClient;
using System.Data;
answered Nov 11 at 6:02
Barr J
5,8831931
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53246187%2fc-sharp-class-wont-allow-sql-directive%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
You are using the wrong namespace here.
Instead of:
using System.Data.SqlTypes;
You should use SqlClient and I recommend also System.Data:
using System.Data.SqlClient;
using System.Data;
answered Nov 11 at 6:02
Barr J
5,8831931
add a comment |
You are using the wrong namespace here.
Instead of:
using System.Data.SqlTypes;
You should use SqlClient and I recommend also System.Data:
using System.Data.SqlClient;
using System.Data;
answered Nov 11 at 6:02
Barr J
5,8831931
add a comment |
You are using the wrong namespace here.
Instead of:
using System.Data.SqlTypes;
You should use SqlClient and I recommend also System.Data:
using System.Data.SqlClient;
using System.Data;
answered Nov 11 at 6:02
Barr J
5,8831931
You are using the wrong namespace here.
Instead of:
using System.Data.SqlTypes;
You should use SqlClient and I recommend also System.Data:
using System.Data.SqlClient;
using System.Data;
answered Nov 11 at 6:02
Barr J
5,8831931
answered Nov 11 at 6:02
Barr J
5,8831931
answered Nov 11 at 6:02
Barr J
5,8831931
answered Nov 11 at 6:02
Barr J
5,8831931
5,8831931
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53246187%2fc-sharp-class-wont-allow-sql-directive%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
What did you want to achieve?
– D-Shih
Nov 11 at 5:52
do you have
System.Data.dlladded to your project references?– styx
Nov 11 at 5:52
replace
using System.Data.SqlTypes;withusing System.Data.SqlClient;– Prix
Nov 11 at 6:01