How to get the data from different tables from different rlinq's using telerik open access

Question

1.00/5 (1 vote)

See more:

hi,
I am using Telerik open Access,I have three different data models like
UserEntitiesModel->account_details
ProfileEntitiesModel->biographic_details
ContactsEntitiesModel->contact_groups

I have three different tables in different datamodels.I want to load the data from all the tables,I used joins and wrote the lambda expression,but it is throwing an exception that "InvalidOperationException unhandled by user code".can u tell me how to retrieve the the data from different tables in diferent datamodels.

Posted 15-Jul-12 21:06pm

charan1431

Updated 16-Jul-12 2:16am

v4

Add a Solution

Comments

Unareshraju 16-Jul-12 8:27am

let me did you connect to database through the LINQ?
please tell me............

charan1431 17-Jul-12 0:54am

I have different entity models in my project.I want to retrieve the data from the tables from different entity models.I wrote the lambda expression to retrieve the data from different entity models but it is throwing Invalid Operation Exception.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Unareshraju · Answer 1 · 2012-07-16T20:02:00

Solution 1

Hi charan,
As i understood.

these three tables have a at least one common column.
depending on them we can use a join operation.
i was got same exception in previous in LINQ but i was took a common column for all table then i used join query after that i worked fine.

please see the my be syntax problem in join command .........

Posted 16-Jul-12 20:02pm

Unareshraju

Comments

Unareshraju 17-Jul-12 2:07am

please see the url:
http://www.databasejournal.com/features/mysql/article.php/3835506/Fetching-Data-from-Multiple-Tables-using-Joins.htm

charan1431 17-Jul-12 2:36am

may i know one thing,U are also retrieving the data from tables with different entity models or same entity model?

Unareshraju 17-Jul-12 2:42am

Same Enitymodel..charan

charan1431 17-Jul-12 2:55am

My query is working fine if i give all tables in one entity model,I am facing problem with different entities models