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! 6 1395
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#)
------------------------------------------------------------------------
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
I am currently working on an Oracle database and I want to try DLinq. I am
wondering if it could work.
"Jan Bannister (jancsharp.blog spot.com)" <ja***********@ gmail.com> ????
news:11******** **************@ g44g2000cwa.goo glegroups.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
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.n l> ????
news:xn******** *******@news.mi crosoft.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#) ------------------------------------------------------------------------
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.n l> ???? news:xn******** *******@news.mi crosoft.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#)
------------------------------------------------------------------------
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.co m
"Lei Jiang" <co**@263.net.N O_SPAM> wrote in message
news:uv******** ******@TK2MSFTN GP14.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!
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Senna |
last post by:
Hi
Have a question about DLinq.
The example code floating around looks like this:
Northwind db = new Northwind(@"C:\...\northwnd.mdf");
var custs = from c in db.Customers where c.City == "London" select c;
How does this work. Will it retreive all the rows from the Customer table
|
by: Chiranjib |
last post by:
I have the following queries/Observations about DLINQ.
1. I could not find any direct way of handling many to many relations.
Suppose if User and Role are related by a join table UserRole then I should
be able to have a collection of Roles in User and vice versa. Which i think
is not possible in DLINQ. (Please correct me if I am wrong)
2. State management is handle outside entities. In scenareos where a client
grabs a entity from a...
|
by: Scott Nonnenberg [MSFT] |
last post by:
This is our first official DLinq chat. We're still early in the planning and
development stage for this very cool technology, so we can react to your
feedback much more easily. Show up and tell us what's on your mind!
Scott Nonnenberg
Program Manager
Visual C# Team
DLinq
"The LINQ Project is a codename for a set of extensions to the .NET
|
by: Brett Romero |
last post by:
I've downloaded the DLINQ samples from Microsoft and have always been
able to compile these in VS.NET 2005 Pro. I have a new project that I
added DLINQ references to and put in a simlpe query. It didn't
compile. I went back to the SampleQueries.sln, compiled and for the
first time it failed. It keeps looking at the query code as if it were
regular c#. It's wanting ";", which the queries don't use. Same thing
is occuring in my other...
|
by: Andrus |
last post by:
I need to update natural primary key like
Territories.TerritoryID column in northwind database.
In pure ADO .NET this is easy. I can use ExecScalar to run UPDATE command
on primary key.
Server referential integrity causes cascade updates automatically.
I read from MSDN that Linq-SQL does not allow to update object ids.
| |
by: Andrus |
last post by:
How to create select columns list dynamically in DLinq ?
I want to create something like
Console.WriteLine("Enter list of columns to return, separated by commas:");
string list = Console.ReadLine();
var q = from c in Db.Customers
where c.Location=="London"
select list;
|
by: Andrus |
last post by:
I need to repeatedly execute same queries which returns single entity by id,
like:
Customer cust = (from c in db.Customers
where c.CustomerID=="AIRBU"
select c).SingleOrDefault();
DLinq holds tracked object list internally so customer "AIRBU" exists in
memory.
|
by: Marc Gravell |
last post by:
How to fix ?
Write it the way that you know works... (i.e. the one you commented
out), or write that parses the input string doing a Split on '.', and
uses reflection to navigate the child hierarchy. Which isn't something I
have time to do right now...
Marc
|
by: Andrus |
last post by:
I need to pass DLinq query to RDLDEsigner.
RDLDesigner does not accept IQueryable<T>.
It accepts SQL select statement in plain text format as data source.
How to get SELECT statement which corresponds to dlinq query
as plain text as it is being sent to server ?
How to create method which allows to grab the sql statement which is being
passed to DataReader without executing DataReader and opening connection.
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
| |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |