How I could update a DB table using a POCO class bound in a DataGridView

Question

I try to explain better using an example:

I create the class Product with attibutes like that:

private string _ProductCode = "";
[DisplayName("ProductCode")]
public String ProductCode
{
   get { return _ProductCode; }
   set { _ProductCode = value; OnPropertyChanged("ProductCode"); }
}

the class Product implements the interfaces: INotifyPropertyChanged, IEditableObject
I create the class ProductList that has the following property:
```
public List<Product> Products { get; set; }
```
I bind the class Product in a DataGridView control using the DataSource property
```
MyGridView.DataSource = ProductList.Products;
```
I have the table ProductListTable on db SqlServer that has more column than the class Product
When I push the button "Save" on my form I'd would like to save the ProductList on ProductListTable

I'm really confusing about the way to follow ... I have to use Link 2 Sql, Entity Framework? I'm searching for something simple for a small project, but using POCO classes for rapresenting the data layer.

Now how I should proceed for linking class to DB table?

I guess you are you using WPF, right? – margabit Aug 21 '13 at 15:14 — margabit, Aug 21 '13 at 15:14

Chris · Answer 1 · 2014-01-12 15:29:54Z

up vote 0 down vote

It sounds like Entity Framework is what you want, specifically using the code first techniques.

With code first you're able to create a 'DbContext' class that can hold DbSet<> objects, similar to your List. These DbSets are linked to the database by entity framework and they will take care of the database interaction as long as you call SaveChanges() on them. This method will allow you to keep you POCO objects.

This book: Programming Entity Framework: Code First is great. It'll quickly bring you up to speed (only a few hundred pages).

I'll also add this as quite a full tutorial without buying a book: Code-First Development with Entity Framework 4

edited Jan 12 at 15:29

Chris
1,1641817

answered Dec 13 '13 at 11:51

Ben Gale
20115

would you mind explaining more on what these resources do and why do you recommend these as answering the question asked? "Link-only answers" are not quite welcome at Stack Exchange – gnat Dec 13 '13 at 12:00

Does that extra paragraph give enough information about EF Code First? Enough that he'd then want to use the links? – Ben Gale Dec 13 '13 at 12:05

add a comment |

asked	11 months ago
viewed	383 times
active	2 days ago

current community

your communities

more stack exchange communities

How I could update a DB table using a POCO class bound in a DataGridView

migrated from codereview.stackexchange.com Aug 21 '13 at 15:13

1 Answer 1

Your Answer

Hot Network Questions

current community

your communities

more stack exchange communities

How I could update a DB table using a POCO class bound in a DataGridView

migrated from codereview.stackexchange.com Aug 21 '13 at 15:13

1 Answer 1

Your Answer

Sign up or log in

Post as a guest

Related

Hot Network Questions