question about linq2mysql and FK,PK relationships (MARS)
Posted: Thu 02 Oct 2008 21:13
Hi,
First of all i would like to thank you guys very much for the great job developing linq2mysql!.
I'm really into this, and if i can be of any assistance during developing/testing of this product, please do let me know.
Do you want me to send you guys flowers for making this product ?
I already started developing with the linqsupport beta, but i've noticed the following:
- I use visual studio 2008 with the 3.5 framework
- I am using innodb tables, for making a relational database.
- I used linqsupport beta to reverse enigineer the linq classes.
So, now it seems that when i'm writing a linq query, that at the moment there is no support for a 'lazy read', meaning that when i retrieve a objectcollection (tblUsers for example) with foreign key to another table (tblUserProperties for example), i'm not capable of accessing tblUserProperties from that query.
in other words, in the beta, so it seems the linqsupport is not capable of creating/managing joins to other tables.
linq Code example:
var module = from m in db.Modules
where m.Modulesinroless. --> here the intellisense stops, but i should be able to retrieve the properties of the 'modulesinrows' table, because they have a innodb reference.
(so i've read for sql server), the DB needs to support MARS (Multiple Active Result Sets), but i don't find any relevant hits on google for MySql and MARS).
---------------
QUESTION:
----------------
Is your linq2mysql product going to support 'quering with DB relationships'
First of all i would like to thank you guys very much for the great job developing linq2mysql!.
I'm really into this, and if i can be of any assistance during developing/testing of this product, please do let me know.
Do you want me to send you guys flowers for making this product ?
I already started developing with the linqsupport beta, but i've noticed the following:
- I use visual studio 2008 with the 3.5 framework
- I am using innodb tables, for making a relational database.
- I used linqsupport beta to reverse enigineer the linq classes.
So, now it seems that when i'm writing a linq query, that at the moment there is no support for a 'lazy read', meaning that when i retrieve a objectcollection (tblUsers for example) with foreign key to another table (tblUserProperties for example), i'm not capable of accessing tblUserProperties from that query.
in other words, in the beta, so it seems the linqsupport is not capable of creating/managing joins to other tables.
linq Code example:
var module = from m in db.Modules
where m.Modulesinroless. --> here the intellisense stops, but i should be able to retrieve the properties of the 'modulesinrows' table, because they have a innodb reference.
(so i've read for sql server), the DB needs to support MARS (Multiple Active Result Sets), but i don't find any relevant hits on google for MySql and MARS).
---------------
QUESTION:
----------------
Is your linq2mysql product going to support 'quering with DB relationships'