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)?](https://stackoverflow.com/questions/20901419/how-to-call-stored-procedure-in-entity-framework-6-code-first) — gsharp, Jul 17 '19 at 03:20

score 1 · Accepted Answer · answered Jul 17 '19 at 03:27

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 '19 at 03:27

Rowan Freeman

2

but that's not all. "exec" is not required and Customer should be passed as a parameter. – gsharp Jul 17 '19 at 03:29
Thanks everyone. Removed the exec and changed the SqlRes's property to 'data', and now it works. – Stackedup Jul 17 '19 at 03:59

1 Answers1