Database development

[Hemang Shah]

Hello I"m a seasonal Access developer.

How steep is the learning curve to start developing database applications
in c# ?

Could you suggest me any good books which teaches the ropes of

database development in C# ? Including making reports ?



Thanks

 

[Guest]

You don't really write a database "in C#".
Do you mean you want to write a database *backend* in C#, or you want to
write an application that *uses* a database (running on an existing backend)
in C#?
If the former, then it's no small task, and it'd probably be fairly poor if
it didn't use at least a bit of C/C++. If the latter, then SQL Server (free
versions are MSDE 2000 or SQL Server Express 2005 Yukon) is the best bet as
it includes support for stored procedures which enable you to isolate a layer
of processing to the backend, black-box-ed off to your C# app. Watch out for
Yukon's dodgy new provider though - it doesn't seem to use the standard
OLEDB, instead going for something called "SQL native client". I had a little
dabble with it but it put me off as I had a project to do quickly, but I
might spend further time investigating when I've got the time.
Basically though, C# includes the System.Data.SqlClient namespace which
contains objects for accessing SQL server databases directly without using
OLEDB, hence is probably the fastest way of doing it.

 

[Hemang Shah]

I definately didn't mean writting a whole new database!

I meant writting a front end to MSDE or Access or wotsoever.

Are there any good books on the same ?

Thanks