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