C#•3y ago

✅ SQLConnection and queries to the database

Hey there!
I've been having this problem lately with something i'm writing, which essentially boils down to the following code:

String conn = $@"Server={server};Database={database};Trusted_Connection=True;";
this.Connection = new SqlConnection(connectionString);
this.Connection.Open();
SqlCommand cmd = new SqlCommand("SELECT * FROM Alunos", this.Connection);
SqlDataReader reader = cmd.ExecuteReader();

String conn = $@"Server={server};Database={database};Trusted_Connection=True;";
this.Connection = new SqlConnection(connectionString);
this.Connection.Open();
SqlCommand cmd = new SqlCommand("SELECT * FROM Alunos", this.Connection);
SqlDataReader reader = cmd.ExecuteReader();

String conn = $@"Server={server};Database={database};Trusted_Connection=True;";
this.Connection = new SqlConnection(connectionString);
this.Connection.Open();
SqlCommand cmd = new SqlCommand("SELECT * FROM Alunos", this.Connection);
SqlDataReader reader = cmd.ExecuteReader();

String conn = $@"Server={server};Database={database};Trusted_Connection=True;";
this.Connection = new SqlConnection(connectionString);
this.Connection.Open();
SqlCommand cmd = new SqlCommand("SELECT * FROM Alunos", this.Connection);
SqlDataReader reader = cmd.ExecuteReader();

When I run this, it seems to just not find my

Alunos

Alunos

Alunos

Alunos table, and I end up having to write

[{database}].[dbo].[Alunos]

[{database}].[dbo].[Alunos]

[{database}].[dbo].[Alunos]

[{database}].[dbo].[Alunos] even though I had specified that I wanted to start out with a database in my connection string. What am I doing wrong here? I don't want to have to write my queries with

dbo.(...)

dbo.(...)

dbo.(...)

dbo.(...); I'd rather just switch to the database I want at runtime and then query a table directly

bin01ary•10/31/23, 3:49 PM

When you do a select statement, normally it would be [{database}].[dbo].[Alunos] not dbo.[{database}.Alunos]. Your database name should come before the schema name (dbo).

bin01ary•10/31/23, 3:53 PM

I'm guessing something is wrong with the way your database is setup.

TeBeCo•10/31/23, 3:55 PM

When you do a select statement, normally it would be [{database}].[dbo].[Alunos] not dbo.[{database}.Alunos]. Your database name should come before the schema name (dbo).

~~blablabla ... I miss read~~

Original message was deleted

bin01ary•10/31/23, 3:57 PM

I was referring to when they mentioned dbo.[{database}.Alunos]

TeBeCo•10/31/23, 3:58 PM

oO right

TeBeCo•10/31/23, 3:58 PM

my bad

TeBeCo•10/31/23, 3:59 PM

i'd say it's hard to help without seeing the DB itself

TeBeCo•10/31/23, 3:59 PM

which could be severlly sensitive

TeBeCo•10/31/23, 3:59 PM

like avoid to leak IP / name etc ... of the external infra

Bbin01ary When you do a select statement, normally it would be [{database}].[dbo].[Alunos]...

AlexOP•10/31/23, 4:51 PM

Oh- right I was just stupid and wrote it wrong

AlexOP•10/31/23, 4:51 PM

I'll edit it

AlexOP•10/31/23, 4:54 PM

That is how its written, I just copied it wrong lol

AlexOP•10/31/23, 4:54 PM

Oh wait no it isn't because there's Escola.AlunosEscola.Alunos at the end still

bin01ary•10/31/23, 4:56 PM

The other thing I can suggest is change the first line

String conn = $@"Server={server};Database={database};Trusted_Connection=True;";

String conn = $@"Server={server};Database={database};Trusted_Connection=True;";

so you just use $ instead of $@

bin01ary•10/31/23, 4:56 PM

String conn = $"Server={server};Database={database};Trusted_Connection=True;";

String conn = $"Server={server};Database={database};Trusted_Connection=True;";

bin01ary•10/31/23, 4:59 PM

assuming you have variables for

server

server

and databasedatabase

AlexOP•10/31/23, 4:59 PM

Yep, I do, and that didn't seem to work, but after getting your insight... I think I know what's happening

AlexOP•10/31/23, 4:59 PM

But just to confirm it...

AlexOP•10/31/23, 5:00 PM

CREATE TABLE [Escola.Alunos] (
    NumeroInterno INT IDENTITY (1,1) NOT NULL,
    Nome VARCHAR(50) NOT NULL,
    Idade INT NOT NULL,
    Localidade VARCHAR(50) NOT NULL,

    PRIMARY KEY(NumeroInterno)
)

CREATE TABLE [Escola.Alunos] (
    NumeroInterno INT IDENTITY (1,1) NOT NULL,
    Nome VARCHAR(50) NOT NULL,
    Idade INT NOT NULL,
    Localidade VARCHAR(50) NOT NULL,

    PRIMARY KEY(NumeroInterno)
)

AlexOP•10/31/23, 5:00 PM

When ... I create a table like this... I'm creating a table named "Escola.Alunos""Escola.Alunos" right?

bin01ary•10/31/23, 5:00 PM

yep. Escola.AlunosEscola.Alunos is now your table name.

AlexOP•10/31/23, 5:00 PM

God damnit. Thank you so much

AlexOP•10/31/23, 5:00 PM

That's embarassing

bin01ary•10/31/23, 5:01 PM

it happens to all of us

AlexOP•10/31/23, 5:01 PM

It should be [Escola].[Alunos][Escola].[Alunos] right?

bin01ary•10/31/23, 5:01 PM

is Escola your database name?

AlexOP•10/31/23, 5:01 PM

Yeah

bin01ary•10/31/23, 5:02 PM

you can just do

Alunos

Alunos

if you are running the create statement in the Escola database

bin01ary•10/31/23, 5:02 PM

then you can SELECT * FROM Alunos if you are connected to the Escola database

AlexOP•10/31/23, 5:04 PM

Yep, thank you!

bin01ary•10/31/23, 8:53 PM

$close

Bbin01ary $close

MODiX•10/31/23, 8:53 PM

Use the </close:1007753098107813888> command to mark a forum thread as answered

✅ SQLConnection and queries to the database

Similar Threads

Similar Threads

Similar Threads