VS2008 - different ways to work with MS SQL Server database

[Just D]

All,

Returning to WinForms - what is the current situation with the MS SQL
Server database access? Did anybody see any good review or can just give us
his own impression about that? I'd like to get a more or less complete list
of different ways accessing MS SQL database from C# in WinForms.

1. VS2008 - Create a new DataSource, generate query, select the datasource
type and d-n-d to the WinForm to autogenerate the controls and bind data to
them.
2. SqlHelper - automatically or manually retrieve the DataSet and work with
it parsing data, updating it, etc. SqlHelper.Execu teDataSet or any other
method to Fill the data is ok.
3. Manually or automatically generated classes loading the data from
DataSets, DataReaders, etc., updating the data on the database, etc.
4. Some libraries including the open source libs to generate the data access
layer and simplify writing of the code. Btw, what libraries are popular for
WinForms now?

What else?


Thanks,
Just D.

[sloan]

Re: VS2008 - different ways to work with MS SQL Server database


http://sholliday.space s.live.com/Blog/cns!A68482B9628 A842A!139.entry

http://sholliday.spaces.live.com/feed.rss

Some of it depends on whether or not you are concerned about RAPID
development.
I (for one) an 99.9% NOT concerned about RAPID development.

Therefore I now lean toward custom objects / collections for development.

I consider a (strong) DataSet, a poor mans business object.

at the first URL above, there is a MS article "bird's eye view" is what I
call it at the blog.

I would read that article twice over, and bookmark it.

Check the other blog entries I have for later versions of the custom class /
collection examples.




"Just D" <no@spam.please wrote in message
news:yuaUk.2115 7$us4.9653@news fe14.iad...

All,
>
Returning to WinForms - what is the current situation with the MS SQL
Server database access? Did anybody see any good review or can just give
us his own impression about that? I'd like to get a more or less complete
list of different ways accessing MS SQL database from C# in WinForms.
>
1. VS2008 - Create a new DataSource, generate query, select the datasource
type and d-n-d to the WinForm to autogenerate the controls and bind data
to them.
2. SqlHelper - automatically or manually retrieve the DataSet and work
with it parsing data, updating it, etc. SqlHelper.Execu teDataSet or any
other method to Fill the data is ok.
3. Manually or automatically generated classes loading the data from
DataSets, DataReaders, etc., updating the data on the database, etc.
4. Some libraries including the open source libs to generate the data
access layer and simplify writing of the code. Btw, what libraries are
popular for WinForms now?
>
What else?
>
>
Thanks,
Just D.
>
>