Does the 'Datalength' command from T-sql have a c# Lambda equivalent?

Question

In T-SQL, I can write:

select datalength(somecolumn_that_is_defined_as_text) from somedatabase

and it returns the length, in bytes, of that column.

Can this be done in using a Lambda expression?

I don't know about lambda, but ExecuteQuery-T should work – Marc Gravell Dec 03 '10 at 19:59 — Marc Gravell, Dec 03 '10 at 19:59

Thymine · Answer 1 · 2012-04-12T19:06:28.383

1

It looks like they added it in .Net 4.0

~~You should be able to add it to 3.5 at least by using EdmFunctionAttribute on your own function call (I'm not finding a good example of this right now)~~

EdmFunctionAttribute is .Net 4.0 too. So I can't find any way to achieve this in .Net 3.5 Lambda statements.

edited Apr 12 '12 at 19:06

answered Feb 08 '12 at 21:31

Thymine

8,775
2
35
47

score 0 · Answer 2 · answered Dec 03 '10 at 20:03

0

Maybe use Encoding.GetBytes(MyColumnValue).Length on the values?

answered Dec 03 '10 at 20:03

Mike Cheel

12,626
10
72
101

This is not valid because that would give the bytes in CLR after its been converted from the SQL datatype (So it would give the string's bytes not the nvarchar's bytes) and would only work on strings – Thymine Feb 08 '12 at 21:34

Does the 'Datalength' command from T-sql have a c# Lambda equivalent?

2 Answers2