29 January 2014

SQL Server Naming conventions and Standards

Today , we will discuss about SQL Server Name Conventions and Standards

  1. Table >> tbl >>tblEmployees
  2. Primary Key Constraint >> PK >>PK_EmployeeId
  3. Foreign Key Constraint>> FK >> FK_Employeeid
  4. Unique Key Constraint>> UQ >>UQ_employee_EmailId
  5. Default Constraint >> DF >> DF_Employee_IsActive
  6. Check Constraint >> CHk >> CHK_Employee_DOB
  7. User defined Store Procedure >> usp Eg:usp_Insert_Employee
  8. User Defined Functions >> fn >> fn_CalculateAge
  9. Views >> vw >> vw_OrderDetails
  10. Triggers >> trg >> trg_Del_Employee
  11. Indexes >> IX >>IX_EmployeeEmailId

23 December 2013

Supporting Namespace in Dotnet 4.5


S.NoParticular.Net 3.0.Net 3.5.Net 4.0.Net 4.5
1Microsoft.Build.Tasks.WindowsYYYY
2Microsoft.Win32YYYY
3Microsoft.Windows.ThemesYYYY
4System.Collections.ObjectModel YYYY
5System.Collections.SpecializedYYYY
6System.ComponentModel YYYY
7System.DiagnosticsYYYY
8System.IOYYYY
9System.IO.PackageYYYY
10System.PrintingYYYY
11System.Printing.IndexedPropertyYYYY
12System.Printing.InteropYYYY
13System.Security.PermissionsYYYY
14System.Security.RightsManagementYYYY
15System.WindowsYYYY
16System.Windows.AnnotationsYYYY
17System.Windows.Annotations.StorageYYYY
18System.Windows.AutomationYYYY
19System.Windows.Automation.PeersYYYY
20System.Windows.Automation.ProviderYYYY
21System.Windows.Automation.TextYYYY
22System.Windows.ControlsYYYY
23System.Windows.Controls.PrimitivesYYYY
24System.Windows.ConvertersYYYY
25System.Windows.DataYYYY
26System.Windows.DocumentsYYYY
27System.Windows.Documents.DocumentStructuresYYNY
28System.Windows.Documents.SerializationYYYY
29System.Windows.Forms.IntegrationYYYY
30System.Windows.InkYYYY
31System.Windows.InputYYYY
32System.Windows.Input.StylusPlugInsYYYY
33System.Windows.InteropYYYY
34System.Windows.Markup (shared)YYYY
35System.Windows.Markup.LocalizerYYYY
36System.Windows.Markup.PrimitivesYYYY
37System.Windows.MediaYYYY
38System.Windows.Media.AnimationYYYY
39System.Windows.Media.ConvertersYYYY
40System.Windows.Media.EffectsYYYY
41System.Windows.Media.ImagingYYYY
42System.Windows.Media.Media3DYYYY
43System.Windows.Media.Media3D.ConvertersYYYY
44System.Windows.Media.TextFormattingYYYY
45System.Windows.NavigationYYYY
46System.Windows.ResourcesYYYY
47System.Windows.ShapesYYYY
48System.Windows.ThreadingYYYY
49System.Windows.XpsYYYY
50System.Windows.Xps.PackagingYYYY
51System.Windows.Xps.SerializationYYYY
52UIAutomationClientsideProvidersYYYY

22 December 2013

Supporting Namespace for Sliverlight in Net


S.NoParticularSliverlight
1Microsoft.Win32Y
2Microsoft.Windows.ThemesY
3System.Collections.ObjectModel Y
4System.Collections.SpecializedY
5System.ComponentModel Y
6System.DiagnosticsY
7System.IOY
8System.Security.PermissionsY
9System.WindowsY
10System.Windows.AutomationY
11System.Windows.Automation.PeersY
12System.Windows.Automation.ProviderY
13System.Windows.Automation.TextY
14System.Windows.ControlsY
15System.Windows.Controls.PrimitivesY
16System.Windows.DataY
17System.Windows.DocumentsY
18System.Windows.Documents.DocumentStructuresY
19System.Windows.Documents.SerializationY
20System.Windows.Forms.IntegrationY
21System.Windows.InkY
22System.Windows.InputY
23System.Windows.InteropY
24System.Windows.Markup (shared)Y
25System.Windows.MediaY
26System.Windows.Media.AnimationY
27System.Windows.Media.EffectsY
28System.Windows.Media.ImagingY
29System.Windows.Media.Media3DY
30System.Windows.NavigationY
31System.Windows.ResourcesY
32System.Windows.ShapesY
33System.Windows.ThreadingY