SqlQuery result : Microsoft.Data.SqlClient.SqlException: 'Invalid column name : 'Value'.'

Question

I have this EF Core query on a SQL Server database to get the database collation (code from Copilot):

var collation = dbContext.Database.SqlQuery<string>($"SELECT collation_name FROM sys.databases WHERE name = DB_NAME()").FirstOrDefault();

I get this response:

SqlQuery result : Microsoft.Data.SqlClient.SqlException: 'Nom de colonne non valide : 'Value'.'

Translation (I think):

SqlQuery result : Microsoft.Data.SqlClient.SqlException: 'Invalid column name : 'Value'.'

I'm using

Microsoft.EntityFrameworkCore (9.0.7)
Microsoft SQL Server 2019 (RTM-CU32-GDR) (KB5058722) - 15.0.4435.7 (X64)

Why does this happen?

Charlieface · Accepted Answer · 2025-07-30 15:23:51Z

6

SqlQuery expects the single column to be called Value.

Also database_id is the primary key, you should use that.

var collation = dbContext.Database.SqlQuery<string>(
   $"""
       SELECT collation_name AS Value
       FROM sys.databases
       WHERE database_id = DB_ID()
    """).FirstOrDefault();

edited Jul 30 at 15:23

answered Jul 30 at 15:15

Charlieface

78.5k8 gold badges35 silver badges77 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Eric Ouellet Jul 30 at 15:29

It works with "name = DB_NAME()" because it returns a single row but I agree it is a better practice to use the primary key instead and I will change my code to follow yours!

Collectives™ on Stack Overflow

SqlQuery result : Microsoft.Data.SqlClient.SqlException: 'Invalid column name : 'Value'.'

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related