Code first with stored procedure output column mapping when spaces in output column name

Asked Apr 21 '15 at 15:09

Active Apr 21 '15 at 15:35

Viewed 1,299 times

What is the best way to handle this situation. I am working with legacy stored procedures and one of the stored procedures uses code like this

select c.Name AS 'Company Name' ...

I want to execute the stored procedure and have it map to my model correctly but what should I name the variable if the returned column has a space in it? Do I use the actual DB table column name as a fallback?

Example:

SqlQuery<MyCustomModel>("exec MyStoredProcedure").ToList<MyCustomModel>();

My Model:

class MyCustomModel
{
    public String Company_Name { get; set; } //<-What do I do here? 
}

edited Apr 21 '15 at 15:35

DavidG

113,891
12
217
223

asked Apr 21 '15 at 15:09

Ellery

1,356
1
14
22

Have you tried added this attribute to the `Company_Name` property: `[Column("Company Name")]`? – DavidG Apr 21 '15 at 15:28
In the model? @DavidG – Ellery Apr 21 '15 at 15:30
Yes, on the property in your model. – DavidG Apr 21 '15 at 15:30
I didn't know you could do that ill try it now @DavidG – Ellery Apr 21 '15 at 15:31
@Ellery Did that work? – drizzie Feb 16 '17 at 16:37

Code first with stored procedure output column mapping when spaces in output column name

0 Answers0