Simple.Data select a constant value into column

Asked Aug 30 '16 at 05:30

Active Aug 30 '16 at 05:30

Viewed 55 times

Is there a way with Simple.Data to add a column to a query where the column will just contain some constant? For example it would be similar to this query:

SELECT Name, 'Unpaid' AS Status FROM table;

I would like to do something similar to the 'Unpaid' part in this query.

asked Aug 30 '16 at 05:30

Reasurria

1,808
16
14

This query looks spot on as it is. Have you actually tried it? – Tim Biegeleisen Aug 30 '16 at 05:35
@TimBiegeleisen Hey Tim. Thanks for the input. Please note the "Simple.Data" part. It is a .NET ORM. – Reasurria Aug 30 '16 at 05:36
I don't know this API at all, but the cop out answer would be to just modify your underlying data structure to contain this temporary data. – Tim Biegeleisen Aug 30 '16 at 05:39
1

@TimBiegeleisen It is an option but I would only use it as a last resort. – Reasurria Aug 30 '16 at 05:40

Simple.Data select a constant value into column

0 Answers0