How to do CRUD operations Windows Forms Using Entity Framework in C#

Question

1.00/5 (1 vote)

See more:

Hai

This is Tarun

I want to do CRUD Operations in Windows Forms Using Entity Framework.

Would you please tell me how to do this.

I already tried this article Entity Framework in WinForms[^] But Here It did n't enable entitydatasource control in this.

Kindly Reply me

Posted 27-Jan-15 18:57pm

TarunKumarSusarapu

Updated 29-Jan-15 0:10am

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)

Atish K. Singh · Answer 1 · 2015-01-27T20:28:00

Solution 1

Install "EF Tools for appropriate Visual Studio version.

Follow this link http://dev.mysql.com/doc/connector-net/en/connector-net-tutorials-entity-framework-winform-data-source.html[^]

Posted 27-Jan-15 20:28pm

Atish K. Singh

Comments

TarunKumarSusarapu 28-Jan-15 2:31am

Thank you for your information I already tried this but i want to do crud operations using EntityDataSource Control.

Atish K. Singh 28-Jan-15 4:33am

Download the sample. You will get 2 projects;
1. Sample
2. EF6Winforms

Add the reference of ef6winforms in your project. After adding you will be able to see EF6WinformComponents in the Toolbox. Add EntityDataSource in your winform and follow the steps provided in the article.

It is working fine for me.

TarunKumarSusarapu 28-Jan-15 5:01am

K Its Working Thank you for your information.But They have created classes for entity datasource and navigator.I want to take from toolbox by default.How to enable that in toolbox.

Atish K. Singh 28-Jan-15 5:06am

Those are user controls. EntityDataSource is available only for ASP .net as Nuget package. It is not for Winforms.
What is the problem using the given solution? Can you please elaborate?

TarunKumarSusarapu 28-Jan-15 5:35am

Sorry to disturb you. I added Entity Data Source control to toolbox in my project. I have taken that into form but it is showing only none not showing any datasource in property ObjectContextType in EntityDataSource Control Properties.Can u Please solve this

Atish K. Singh 28-Jan-15 6:19am

Have you added ADO .Net Entity Data model in your project?

TarunKumarSusarapu 28-Jan-15 6:29am

Yes I have added but it is not showing on that property.

Atish K. Singh 28-Jan-15 6:34am

Build the solution once and then try.

TarunKumarSusarapu 28-Jan-15 6:37am

I tried but no use

Atish K. Singh 28-Jan-15 6:54am

After adding ADO .Net Entity Data Model and EntityDataSource Control, I am able to select my entity in DBContext property of EntityDataSource.

Please post the steps you have followed till now.

TarunKumarSusarapu 28-Jan-15 7:02am

At first I have added Entity Data Model to the solution. Later I added Entity Data Source Control to the form from the toolbox then i selected EntityDataSource Control Properties there it is showing only ObjectContextType Property not DbContext Type Property there I am getting only none instead of DataContext in Entity Model.

Atish K. Singh 28-Jan-15 7:03am

Which version of EF and VS are you using?

TarunKumarSusarapu 28-Jan-15 7:05am

EF6 and VS2012

Atish K. Singh 28-Jan-15 7:21am

Steps I have followed:

1. Add EF6Winforms to the project.
2. Add ADO .Net Entity Data Model.
3. Save the edmx file and build the solution.
4. Add EntityDataSource control from toolbox to the winform.
5. Select the DBContextType property of EntityDataSource to the Entity added previously.
6. Add a DataGridview to the Form.
7. Select EntityDataSource as the DataSource of the DataGridView.
8. Select the DataMember of the DataGridView.

run the project. Everything is working fine.

Atish K. Singh 28-Jan-15 7:21am

I am also using EF 6.0 with VS2012 express.

TarunKumarSusarapu 28-Jan-15 7:32am

Same Thing I have done but it is not getting.Is there any another way to do this