|
|
| Stop not till the goal is reached. => SV | |
| Sno | TRUNCATE | DELETE |
| 1 | TRUNCATE is faster | Comparitively slower. |
| 2 | Removes all rows from a table | Can remove specific rows with Where clause |
| 3 | Can not be Rolled back. | Can be. |
| 4 | Is DDL | Is DML Command. |
| 5 | Resets identity of the | Does not. |
| 6 | Removes the data by deallocating the data pages and | Removes one row at a time and records an entry in |
| Sno | Primarykey | Unique key |
| 1 | Creates Clustered index. | Creates Non-Clustered index. |
| 2 | Null values are not allowed | Allows. |
| Sno | Inline code | Code Behind Code |
| 1 | Its within .aspx file. | Its in a external class file. |
| 2 | Dynamically compiled. | Compiled prior to deployment and linked with .aspx file. |
| Sno | TypeOf() | GetType() |
| 1 | Its an operator. | Its a method. |
| 2 | Can't be overloaded | Has lot of overloads. |
| Sno | Dll | Exe |
| 1 | Objects of DLLs can be created | Cant |
| 2 | In-Process | Out-Process |
| 3 | Cant be started as a standalone. | Can be. |
| Sno | GroupBox | Panel |
| 1 | Has a visible caption | No |
| 2 | Always displays a border | Border is determined by BorderStyle Property. |
| 3 | Doesnot support scrolling | Enables automatic scrolling using AutoScroll property. |
| Sno | Folder | Purpose |
| 1 | App_Code | This folder is for the Non-page class files that are compiled together to create a single assembly. |
| 2 | App_Data | For the Database files used by the application. |
| 3 | App_Themes | For the Themes used by the application. |
| 4 | Bin | For the Compiled code used by the application |
| Sno | Class | Structure |
| 1 | Reference Type | Value Type |
| 2 | Stored in heap | Stored in stack |
| 3 | Inheritance is available | Not |
| 4 | Protected Modifier is allowed | Not |
| 5 | Construtor is mandatory | Not |
| 5 | Objects are destroyed in GC | Not |
| Sno | global.asax | web.config |
| 1 | Class File | Its an XML file |
| 2 | There can be only one for an application | there can be many if under different sub-folders |
| 3 | Can have Application and Session events | Can't |
| 4 | Need to be recompiled when changes are made | No need to compile when changes are made. |
Two debugging tools come with .NET, they are :
1. CorDBG
– command-line debugger
2. DbgCLR – graphic debugger.
| Sno | const | readonly |
| 1 | Can't be static. | Can be instance level or static |
| 2 | evaluated at design time | evaluated at run time |
| 3 | Initialized at declaration | Initialized at declaration and in constructor |
| 4 | must be of integral type or enumeration | In addition it can have complex types with new keyword and enumerations are not allowed |
