Questions on DLinq

[Lei Jiang]

1) Is it support other database other than SQL Server, such as Oracle,
Sybase?

2) How about the performance? Does it relay on reflections to bind the value
from databse to Entity object?

Thanks!

[Frans Bouma [C# MVP]]

Lei Jiang wrote:

1) Is it support other database other than SQL Server, such as
Oracle, Sybase?
To be discussed, I can't comment on that.
2) How about the performance? Does it relay on reflections to bind
the value from databse to Entity object?

It's my understanding the compiler (C# 3.0 compiler) generates code
which utilizes the attributes of the referenced assembly in the
project, and therefore does the reflection of the attributes at compile
time, rather than at runtime.

FB

--
------------------------------------------------------------------------
Get LLBLGen Pro, productive O/R mapping for .NET: http://www.llblgen.com
My .NET blog: http://weblogs.asp.net/fbouma
Microsoft MVP (C#)
------------------------------------------------------------------------

[Jan Bannister (jancsharp.blogspot.com)]

Hi Lei,

From my understand of it the query expressions are compiled (or more

correctly: translated) into plain old SQL. I don't know the variant of
SQL output but since none of the big vendor implement SQL92 or SQL99 it
doesn't really matter. But in DLinq is not for SQLServer only.

Actually I'd say that it would work really well on MySQL since the Open
Source boys love their standards compliance.

Hope that helps,
Jan

[Lei Jiang]

I am currently working on an Oracle database and I want to try DLinq. I am
wondering if it could work.

"Jan Bannister (jancsharp.blogspot.com)" <ja***********@gmail.com> ????
news:11**********************@g44g2000cwa.googlegr oups.com...

Hi Lei,

From my understand of it the query expressions are compiled (or more

correctly: translated) into plain old SQL. I don't know the variant of
SQL output but since none of the big vendor implement SQL92 or SQL99 it
doesn't really matter. But in DLinq is not for SQLServer only.

Actually I'd say that it would work really well on MySQL since the Open
Source boys love their standards compliance.

Hope that helps,
Jan

[Lei Jiang]

Are you sure it does not use Reflection at runtime? I have tried some O/R
mapping library (such as NHibernate) and found that the reflection wastes a
lot of time.

"Frans Bouma [C# MVP]" <pe******************@xs4all.nl> ????
news:xn***************@news.microsoft.com...

Lei Jiang wrote:

1) Is it support other database other than SQL Server, such as
Oracle, Sybase?

To be discussed, I can't comment on that.

2) How about the performance? Does it relay on reflections to bind
the value from databse to Entity object?

It's my understanding the compiler (C# 3.0 compiler) generates code
which utilizes the attributes of the referenced assembly in the
project, and therefore does the reflection of the attributes at compile
time, rather than at runtime.

FB

--
------------------------------------------------------------------------
Get LLBLGen Pro, productive O/R mapping for .NET: http://www.llblgen.com
My .NET blog: http://weblogs.asp.net/fbouma
Microsoft MVP (C#)
------------------------------------------------------------------------

[Frans Bouma [C# MVP]]

Lei Jiang wrote:

Are you sure it does not use Reflection at runtime? I have tried some
O/R mapping library (such as NHibernate) and found that the
reflection wastes a lot of time.
not 100% sure, I only assume it won't use reflection at runtime, as it
already knows the stuff at compile time, so why not emitting it into
the code directly..

Reflection doesnt have to be that slow either, you can cache property
getter/setters reflected for example. Though nothing beats code
generation ;)

FB

"Frans Bouma [C# MVP]" <pe******************@xs4all.nl> ????
news:xn***************@news.microsoft.com...

Lei Jiang wrote:

1) Is it support other database other than SQL Server, such as
Oracle, Sybase?

To be discussed, I can't comment on that.

2) How about the performance? Does it relay on reflections to bind
the value from databse to Entity object?

It's my understanding the compiler (C# 3.0 compiler) generates code
which utilizes the attributes of the referenced assembly in the
project, and therefore does the reflection of the attributes at
compile time, rather than at runtime.

--
------------------------------------------------------------------------
Get LLBLGen Pro, productive O/R mapping for .NET: http://www.llblgen.com
My .NET blog: http://weblogs.asp.net/fbouma
Microsoft MVP (C#)
------------------------------------------------------------------------

[Nicholas Paldino [.NET/C# MVP]]

Lei,

Based on the document at (watch for line wrap):

http://msdn.microsoft.com/netframewo...qprojec_topic6

In the section titled "SQL Integration", it states:

To issue a query against a relational store, the DLinq implementation of the
LINQ pattern translates the query from its expression tree form into a SQL
expression and ADO.NET DbCommand object suitable for remote evaluation

So basically, its constructing a query that is sent to the server. I
can't imagine that they would not open this up to other data providers (as a
matter of fact, you could probably do it on your own with the bits that they
released).

It just so happens that they targeted SQL Server first (I wonder why,
haha).

Hope this helps.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"Lei Jiang" <co**@263.net.NO_SPAM> wrote in message
news:uv**************@TK2MSFTNGP14.phx.gbl...

1) Is it support other database other than SQL Server, such as Oracle,
Sybase?

2) How about the performance? Does it relay on reflections to bind the
value from databse to Entity object?

Thanks!