Getting table size using Entity Framework

Question

I am using EF6 and I am trying to get the table sizes. I believe this should work but the result comes back as zero:

public class SqlRes{
    public int Size { get; set; }
}

var size = DbContext.Database.SqlQuery<SqlRes>("exec sp_spaceused Customer").ToList();

I have also tried to use type like string or int with no success. Please help.

Possible duplicate of How to call Stored Procedure in Entity Framework 6 (Code-First)? — gsharp
– gsharp, Commented Jul 17, 2019 at 3:20
Could you update the question to what you used to get it working? — ShhTot
– ShhTot, Commented May 13 at 11:07

Rowan Freeman · Accepted Answer · 2019-07-17 03:27:07Z

1

The property names of SqlRes should match the column names returned by the stored procedure.

According to SQL Docs, the column names are:

Try changing your SqlRes class to have those property names.

answered Jul 17, 2019 at 3:27

Rowan Freeman

16.5k12 gold badges72 silver badges104 bronze badges

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

2 Comments

but that's not all. "exec" is not required and Customer should be passed as a parameter.

Thanks everyone. Removed the exec and changed the SqlRes's property to 'data', and now it works.