general architecture - connecting to SQL SERVER

[ronlahav]

Ok thats will be hard

i have enough knowledge in C# language to write almost anything, Serializations, Generics, ADO.NET Etc - all the time i developed as part of a team for local data base.

BUT i have lack of knowledge how to combines things into one projecrt!!!

for example - lets assume that i develope winform app. i have remote SQL server with its own IP addr.

what is the architecture of developing such program - where do i put the connection string and where i stores the file of the connection string, DAL, mmm - how do i call the SQL server, how do i manage the data trafic, and presets it to the client etc.......i hope the point was clarified....

i will be happy for relevant links, code samples...etc....



thanks alot

[jmcilhinney]

The connection string is a matter for the DAL. You might even choose to put connection string management in its own assembly, as I have in my current project that requires failover to a local database when the master is offline.

If you want the user to be able to set connection properties then you need to provide a facility to pass the connection strings up from the DAL, through the BLL to the PL. You would then use an SqlConnectionStringBuilder to break the string up into its constituent properties and display them to the user. Once editing is complete the complete connection string is retrieved from the builder and passed back down through the BLL to the DAL, where it would be saved and used for all subsequent connections.

Where you save it is up to you. Maybe the registry, maybe a config file, maybe a serialised settings object of your own creation, etc., etc.

[ronlahav]

thnks for the reply!
is there any relevant links with which i can read more detail how to design client server applications??

[jmcilhinney]

I'm sure there are.

[mendhak]

thnks for the reply!
is there any relevant links with which i can read more detail how to design client server applications??

This is usually where sitting down with the team to chalk out ideas comes in. You gain from each others' experience and add to your own.