ansaurus

Question

LINQ to SQL and Column Alias with spaces

Answer 1

A:

As far as I know, you can't do this because columns alias must be valid C# identifiers, and they don't allow whitespaces.

eKek0 2009-05-12 14:19:13

Answer 2

+2 A:

First of all Alias's can't have spaces, just like any variable name can't have a space. My question tho is why would you want/need to have a space in your name? I'm sure there are better means of accomplishing what your trying to achieve with out trying to institute bad practices of bad naming conventions.

David Yancey 2009-05-12 14:21:00

You can only have a space in your alias if you are using T-SQL, Select * from Mytable [My table Name]. But like david said, there is no point to having a space in your code. If you really needed to, use the _

Jason Heine 2009-05-12 14:22:38

Thanks! The reason for looking for a space is b/c the data returned is in an IList"Return q.ToList"At this point I simply bind this to a rad grid. The grid column header takes the column names. I was looking for a simple approach for spaces in the column header on the grid.Knowing that alias can't have spaces I will modify the header manually. Thanks for the quick responses!

sugarcrum 2009-05-12 14:41:16

Answer 3

A:

You can't, sorry. Hell, if you bring a table with a space in the name into Linq it will automatically replace the space with underscores.

Besides it not being possible, it is an extremely overwhelmingly bad idea. Something that people that wrote Access should be shot because of.

Serapth 2009-05-12 14:22:27

ansaurus

tags:

views:

answers:

LINQ to SQL and Column Alias with spaces

related questions