Design and Architecture

Have a look at dofactoryhttp://dofactory.com/Default.aspx[^] for details of common patterns, along with code. "WPF has many lovers. It's a veritable porn star!" - Josh Smith As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes. My blog | My articles | MoXAML PowerToys | Onyx

If you are using a stored proc this may help. Where @SetID is the criteria from the client, -1 can be any value. There is a neater method floating around somewhere but I have not changed mine for a decade or more. Search for 'Dynamic where clause'. AND (ISNULL(@SetID,-1) = -1 OR FileSetID = @SetID) Also the EmployeeID in (@List) will not work, you need a Split function that returns a resultset and then you can use an inner join or where in method.

do not publish the same question in two or more forums. Pick one and stick to it. Those are the rules around here. :) Luc Pattyn :badger: :jig: :badger: Have a look at my entry for the lean-and-mean competition; please provide comments, feedback, discussion, and don’t forget to vote for it! Thank you. :jig: :badger: :jig:

Thanks Eddy, I have implemented the strategy pattern. I am afraid my classes caused little bit over kill though it is not the problem of design patterns. Thanks and regards, Majee

Correct, I agree with you. Sometimes we cannot afford a layered architecture. It is not practical also. Architecture should be based on Application demand. Thanks for pointing this out.

Yes, it's possible to update the application after deployment. There are multiple ways of updating, where the simplest is a ClickOnce-installation. Alternatively, you can load an assembly dynamically, check out what classes are defined within, and even instantiate[^] the classes of your liking. There's a CodeProject[^] article showing how to build plugins that way :)

I think that you need to stop worrying about the .NET focus and read more on object-oriented design. You can, then, translate that to many different OO languages. Furthermore, it will help your programming more than just learning from .NET-focused studies. Once you do that, harnesses like CSLA.NET will make a lot more sense to you. "we must lose precision to make significant statements about complex systems." -deKorvin on uncertainty

I have built 2 learning management systems from the ground up in ASP.NET/C# and SQL Server. This is going to be a long task depending on the business requirements. Have fun with SCORM and AICC. You might want to give some thought in buying a low cost LMS or using a free one like Moodle. The first one I build took 2 years because of all the features it needed. Like the previous poster said....get the business requirements first and then go from there. Good luck.

Did you read its documentation, this sort of usage information must be documented some where with application. Share your experience with others Check my Blog...

I my case we need to optimize two tables to stores very large number of records (in millions / billions) - just change the table structure and apply horizontal partitions on date range or no. of records. The new table structure should be able to minimize the records required to store. 1. location_BookedAdvertisement (loc_id, advt_id, start_date, end_date, inventory_text) And data would be like this for location_BookedAdvertisement table: (12, 132, 2009-07-20, 2009-07-25, '1000~2000~5000~8900~3000') This structure reduces the number of rows required to store 100,000 location's date wise assigned inventory by 364 times. Now I only need to store 100,000 rows instead of 100,000 x 365. So I am giving this table structure OK DONE. Also partition this table on no. of records such as 10 millions rows per partition. 2. Now change the structure of tinventory table.. location_ inventory (loc_id, date, Total_available_inventory, booked_inventory) .. to location_ inventory (loc_id, year, Jan1, Jan2, Jan3, Jan4 ,.. ..., Dec29, Dec30, Dec31) And data would be like this for location_ inventory table: (12, 2009, '5000~2000', '10000~8900',... ...,'12000~2000','12000~2000','12000~2000') Here within date column we have 'Total_available_inventory~booked_inventory'. I know there would be 366 column in one table... but today I tested it.... SELECT / INSERT / UPDATE works very very fast as compared to in the earlier table structure. I'll partition this table year-wise i.e based on year column. And this table structure again reduces the required number of records by 364 time... i.e. to store one year inventory of 100,000 locations I would need to store only 100,000 rows. This solution is acceptable.

Thanks.

Thanks. I made them small forms you can just click away with enter or escape. It was necessary to edit anything anyway.

Thanks, man. Have been busy and now found some time to come around here again :D "The clue train passed his station without stopping." - John Simmons / outlaw programmer "Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon "Not only do you continue to babble nonsense, you can't even correctly remember the nonsense you babbled just minutes ago." - Rob Graham