locked
general architecture - connecting to SQL SERVER RRS feed

  • Question

  • 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...i hope the point was clarified....

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

     

    thanks alot

     

    Wednesday, August 8, 2007 6:26 AM

Answers

  • 1.When developinga windows application the best place for storing the connection string will be the app.config file. 

     

    But judging from your question, I think the best thing to do would be to download MS patterns and practices here, this is a framework you could build on top of to create your application.

     

    If your application is really database oriented and you would like to create code that talks to your database, I would recommend using a codegenerator like codesmith and using a codegeneration template like .Nettiers you can learn so much just by looking at the generated code, it is built on top of MS patterns and practices, so I think you should download it and run it against your database. The site also contains a lot of information to get you started.

     

    If .Nettiers are too complicated for you, you will find some easier templates on the codesmith site.

     

    I hope this was helpful.

    Wednesday, August 8, 2007 10:38 PM

All replies

  • 1.When developinga windows application the best place for storing the connection string will be the app.config file. 

     

    But judging from your question, I think the best thing to do would be to download MS patterns and practices here, this is a framework you could build on top of to create your application.

     

    If your application is really database oriented and you would like to create code that talks to your database, I would recommend using a codegenerator like codesmith and using a codegeneration template like .Nettiers you can learn so much just by looking at the generated code, it is built on top of MS patterns and practices, so I think you should download it and run it against your database. The site also contains a lot of information to get you started.

     

    If .Nettiers are too complicated for you, you will find some easier templates on the codesmith site.

     

    I hope this was helpful.

    Wednesday, August 8, 2007 10:38 PM
  • Also take a look at MS patterns and practices software factories: http://msdn2.microsoft.com/en-us/practices/bb190387.aspx.

    Thursday, August 9, 2007 4:07 AM
  • Indeed, MSDN is plenty of such guidance

     

    I suggest you a series of webcasts driven by Prof. Joe Hummel, available here: http://www.microsoft.com/events/series/modernsoftdev.mspx

     

    If you have little time to spend watching webcasts, my 2nd chance is a series of articles on 3 layer .NET architectures

    http://msdn2.microsoft.com/en-us/library/aa581769.aspx

    Tuesday, August 14, 2007 8:42 PM