DLINQ to DataTable ?

Is there a built in way of converting a LINQ qurey result into a DataTable or DataView ?

The LINQ query result is a collection of strongly typed objects. There is no built-in method to do what you want,although it is possible.

|||

I know it is possibe to do this via reflection, however it could be problematic when using anonymous types.

Anyway I was looking for something built-in and I guess there is none which is a shame. Beta versions of DLINQ did have a built in mechanism.

|||

Sorry, I spoke way too soon:http://blogs.msdn.com/erickt/archive/2007/10/24/linq-to-dataset-data-binding-linqdataview-restriction-joins.aspx

AsDataView() would appear to be what you are after.

|||

AsDataView() is not a part of the release version. From what I've read so far it was available in pervious Beta versions. It is only avaiable as a DataTable extension method and it can be used with Linq to DataSet andnot with Linq to SQL.

Dling support?

Hi All.

What can we do to let the power that be know that there are many of us that want Dlinq to support SQL ev?

They say they are considering it, how can we help them deside?

Mike Greenway

You did the right thing by posting the request here - the MS SQL Everywhere team watches this forum and is very responsive to this sort of input. After all, that's how we extended the licensing of SQL Mobile to result in a new release called SQL Everywhere (that and very vocal MVPs).

The one thing about LINQ that I'm sensing is that it is a short-lived idea even on the desktop ADO.NET provider - it may be a stepping stone toward an easier way to achieve ORM, and an initiative is under way called the Entity Management Framework which may supecede the LINQ idea. Just my opinion, not an official statement.

http://msdn.microsoft.com/data/default.aspx?pull=/library/en-us/dnvs05/html/nxtgenda.asp

-Darren

|||

Cool, Great, WOW

What I REALLY want is LINQ and I thought DLINQ was the ONLY way to get it.

ADO.NET's Entity Framework looks like it is VERY handy. If it is truly going to be available in Aug. I'm going to delay writing that part of my code until then.

I never liked SQL strings.

Thank You, again.

Mike

|||

I hate to bring you down to Earth, but DLINQ and/or Entity Framework most certainly won't be available in Aug for devices.

|||

Hi Ilya

What do you think, a CTP in that time frame?

If I had a CTP I could get started.

|||

They did it and the CTP is ahead of schedule too.

http://blogs.msdn.com/adonet/archive/2006/08/15/701479.aspx

I'm going to take a look.

later

Mike Greenway

Dling support?

Hi All.

What can we do to let the power that be know that there are many of us that want Dlinq to support SQL ev?

They say they are considering it, how can we help them deside?

Mike Greenway

You did the right thing by posting the request here - the MS SQL Everywhere team watches this forum and is very responsive to this sort of input. After all, that's how we extended the licensing of SQL Mobile to result in a new release called SQL Everywhere (that and very vocal MVPs).

The one thing about LINQ that I'm sensing is that it is a short-lived idea even on the desktop ADO.NET provider - it may be a stepping stone toward an easier way to achieve ORM, and an initiative is under way called the Entity Management Framework which may supecede the LINQ idea. Just my opinion, not an official statement.

http://msdn.microsoft.com/data/default.aspx?pull=/library/en-us/dnvs05/html/nxtgenda.asp

-Darren

|||

Cool, Great, WOW

What I REALLY want is LINQ and I thought DLINQ was the ONLY way to get it.

ADO.NET's Entity Framework looks like it is VERY handy. If it is truly going to be available in Aug. I'm going to delay writing that part of my code until then.

I never liked SQL strings.

Thank You, again.

Mike

|||

I hate to bring you down to Earth, but DLINQ and/or Entity Framework most certainly won't be available in Aug for devices.

|||

Hi Ilya

What do you think, a CTP in that time frame?

If I had a CTP I could get started.

|||

They did it and the CTP is ahead of schedule too.

http://blogs.msdn.com/adonet/archive/2006/08/15/701479.aspx

I'm going to take a look.

later

Mike Greenway