Is there a namespace for SQL server built in functions like getdate()? Is there a way to access these functions? Intellisense doesn't seem to pick up a way to do either.

What about sys.schemas?

information_schema.columns?

If any of these require a special namespace to access, will the import namespace feature work?

I'd really like to be able to have a query ready that dumps the column names, possibly types, lengths, not null information to an output window so that I can create business objects based on the table definition.

Hi there

There's no way to do this at present. The only way to access a function like getdate() is to map it to a scalar function on SQL Server.

> What about sys.schemas?

You have to use SQL for this. If you want to bring it into C#-land, change the query type to Program and execute the following:



Joe

This post has been edited by JoeAlbahari: Jul 6 2009, 05:24 AM

Is this a limitiation of linq or linqpad?

I think it's possible to do these things in LINQ to SQL with manually-created methods and entities.

Try the following:



Joe