Create Dynamic Query in EF (VB.Net)

Question

0.00/5 (No votes)

See more:

Hi
I explain my problem with an example. (Entity Framework and VB.net 2012)

I have two DataGridViews in my form. first DGV populated from a table in SQL (datasource) and second DGV datasource is an empty table in SQL (By Entitiy Faramwork). user must selects some records from DGV1 and sends them to DGV2 by clicking on a button.

and what is the problem?

when user sends some records from DGV1 to DGV2, transferred records must eliminate from DGV1 without any change on SQL tables. changes finally will be saved by a button clicking.

How can create this relation between DGV1 and DGV2 datasources with out any change to main data in SQL??

I can do this easily in MS Access but i cant do this in EF.

Any help will be greatly appreciated.

Posted 24-May-13 5:54am

r. salehi

Add a Solution

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)

Dave Kreskowiak · Answer 1 · 2013-05-24T07:09:00

Solution 1

It's easy if you think about it. Since you need to keep the data in SQL, you have to keep it's data in a DataTable. You then bind DGV1 to it. When you select the record in DGV1 to tranfer and hit the button, you simply take the data in the selected row and create new EF entities with it, then remove that row from the DataTable. You can then add the new entities to a collection and bind DGV2 to it.

Posted 24-May-13 7:09am

Dave Kreskowiak

Comments

r. salehi 25-May-13 10:38am

Thanks for your reply. would you please show it with code?
Thanks again

Dave Kreskowiak 25-May-13 15:53pm

Nope. I don't have the time to write your code for you.