My Experiments and Experiences

Week Start Date: SELECT DATEADD(dd,1-Datepart(DW,getdate()),GETDATE()) Week End Date: SELECT DATEADD(dd,7-Datepart(DW,getdate()),GETDATE()) Month Start Date SELECT DATEADD(mm, -1,DATEADD(dd, +1, EOMONTH(GetUTCDATE()))) Month End Date SELECT EOMONTH(GetUTCDATE())

Web Application : 1. All Code behind files and standalone class files are compiled into a single assembly. 2. Explicit namespaces are added to pages, controls, and classes by default. 3. The Visual Studio code analysis feature works. 4. Compiling in advance makes sure that users do not have to wait while the site compiles on the production server. Website : 1. Web site projects are compiled dynamically by ASP.NET. basically we have two compilation mode a. Batch compilation mode-> which produces the assembly for folder. b. Fixed compilation mode-> which produces the one assembly for each page or user control. 2. Explicit namespaces are not added to pages, controls, and classes by default, but you can add them manually. 3. Visual Studio code analysis feature does not work. 4. You can test specific pages regardless of the state of other pages. 5. It is easy to update a Web site in production.