Category Archives: programming

>The why of strong name assemblies

>Before extolling the benefits of strong names, let’s begin with a definition. A strong name is made up of information used to identify an assembly and includes the assembly’s text name, four-part version number, culture information (if provided), a public … Continue reading

Posted in .NET, programming | Leave a comment

>What are software engineers think?

> 1. Project Manager is a person who thinks nine women can deliver a baby in one month. 2. Developer is a person who thinks it will take 18 months to deliver a baby. 3. Onsite Coordinator is one who … Continue reading

Posted in programming, relax | Leave a comment

>Common Exception List

>System.AppDomainUnloadedExceptionSystem.ApplicationExceptionSystem.ArgumentExceptionSystem.ArgumentNullExceptionSystem.ArgumentOutOfRangeExceptionSystem.ArithmeticExceptionSystem.ArrayTypeMismatchExceptionSystem.BadImageFormatExceptionSystem.CannotUnloadAppDomainExceptionSystem.ComponentModel.Design.CheckoutExceptionSystem.ComponentModel.Design.Serialization.CodeDomSerializerExceptionSystem.ComponentModel.InvalidEnumArgumentExceptionSystem.ComponentModel.LicenseExceptionSystem.ComponentModel.WarningExceptionSystem.ComponentModel.Win32ExceptionSystem.Configuration.ConfigurationExceptionSystem.ContextMarshalExceptionSystem.Data.ConstraintExceptionSystem.Data.DataExceptionSystem.Data.DBConcurrencyExceptionSystem.Data.DeletedRowInaccessibleExceptionSystem.Data.DuplicateNameExceptionSystem.Data.EvaluateExceptionSystem.Data.ExprExceptionSystem.Data.InRowChangingEventExceptionSystem.Data.InvalidConstraintExceptionSystem.Data.InvalidExpressionExceptionSystem.Data.MissingPrimaryKeyExceptionSystem.Data.NoNullAllowedExceptionSystem.Data.Odbc.OdbcExceptionSystem.Data.OleDb.OleDbExceptionSystem.Data.ReadOnlyExceptionSystem.Data.RowNotInTableExceptionSystem.Data.SqlClient._ValueExceptionSystem.Data.SqlClient.SqlExceptionSystem.Data.SqlTypes.SqlNullValueExceptionSystem.Data.SqlTypes.SqlTruncateExceptionSystem.Data.SqlTypes.SqlTypeExceptionSystem.Data.StrongTypingExceptionSystem.Data.SyntaxErrorExceptionSystem.Data.TypedDataSetGeneratorExceptionSystem.Data.VersionNotFoundExceptionSystem.DivideByZeroExceptionSystem.DllNotFoundExceptionSystem.Drawing.Printing.InvalidPrinterExceptionSystem.DuplicateWaitObjectExceptionSystem.EntryPointNotFoundExceptionSystem.ExceptionSystem.ExecutionEngineExceptionSystem.FieldAccessExceptionSystem.FormatExceptionSystem.IndexOutOfRangeExceptionSystem.InvalidCastExceptionSystem.InvalidOperationExceptionSystem.InvalidProgramExceptionSystem.IO.DirectoryNotFoundExceptionSystem.IO.EndOfStreamExceptionSystem.IO.FileLoadExceptionSystem.IO.FileNotFoundExceptionSystem.IO.InternalBufferOverflowExceptionSystem.IO.IOExceptionSystem.IO.IsolatedStorage.IsolatedStorageExceptionSystem.IO.PathTooLongExceptionSystem.Management.ManagementExceptionSystem.MemberAccessExceptionSystem.Messaging.MessageQueueExceptionSystem.MethodAccessExceptionSystem.MissingFieldExceptionSystem.MissingMemberExceptionSystem.MissingMethodExceptionSystem.MulticastNotSupportedExceptionSystem.Net.CookieExceptionSystem.Net.ProtocolViolationExceptionSystem.Net.Sockets.SocketExceptionSystem.Net.WebExceptionSystem.NotFiniteNumberExceptionSystem.NotImplementedExceptionSystem.NotSupportedExceptionSystem.NullReferenceExceptionSystem.ObjectDisposedExceptionSystem.OutOfMemoryExceptionSystem.OverflowExceptionSystem.PlatformNotSupportedExceptionSystem.RankExceptionSystem.Reflection.AmbiguousMatchExceptionSystem.Reflection.CustomAttributeFormatExceptionSystem.Reflection.InvalidFilterCriteriaExceptionSystem.Reflection.ReflectionTypeLoadExceptionSystem.Reflection.TargetExceptionSystem.Reflection.TargetInvocationExceptionSystem.Reflection.TargetParameterCountExceptionSystem.Resources.MissingManifestResourceExceptionSystem.Runtime.InteropServices.COMExceptionSystem.Runtime.InteropServices.ExternalExceptionSystem.Runtime.InteropServices.InvalidComObjectExceptionSystem.Runtime.InteropServices.InvalidOleVariantTypeExceptionSystem.Runtime.InteropServices.MarshalDirectiveExceptionSystem.Runtime.InteropServices.SafeArrayRankMismatchExceptionSystem.Runtime.InteropServices.SafeArrayTypeMismatchExceptionSystem.Runtime.InteropServices.SEHExceptionSystem.Runtime.Remoting.MetadataServices.SUDSGeneratorExceptionSystem.Runtime.Remoting.MetadataServices.SUDSParserExceptionSystem.Runtime.Remoting.RemotingExceptionSystem.Runtime.Remoting.RemotingTimeoutExceptionSystem.Runtime.Remoting.ServerExceptionSystem.Runtime.Serialization.SerializationExceptionSystem.Security.Cryptography.CryptographicExceptionSystem.Security.Cryptography.CryptographicUnexpectedOperationExceptionSystem.Security.Policy.PolicyExceptionSystem.Security.SecurityExceptionSystem.Security.VerificationExceptionSystem.Security.XmlSyntaxExceptionSystem.ServiceProcess.TimeoutExceptionSystem.StackOverflowExceptionSystem.SystemExceptionSystem.Threading.SynchronizationLockExceptionSystem.Threading.ThreadAbortExceptionSystem.Threading.ThreadInterruptedExceptionSystem.Threading.ThreadStateExceptionSystem.Threading.ThreadStopExceptionSystem.TypeInitializationExceptionSystem.TypeLoadExceptionSystem.TypeUnloadedExceptionSystem.UnauthorizedAccessExceptionSystem.UriFormatExceptionSystem.Web.HttpApplication+CancelModuleExceptionSystem.Web.HttpCompileExceptionSystem.Web.HttpExceptionSystem.Web.HttpParseExceptionSystem.Web.HttpRequestValidationExceptionSystem.Web.HttpUnhandledExceptionSystem.Web.Services.Discovery.InvalidContentTypeExceptionSystem.Web.Services.Discovery.InvalidDocumentContentsExceptionSystem.Web.Services.Protocols.SoapExceptionSystem.Web.Services.Protocols.SoapHeaderExceptionSystem.Windows.Forms.AxHost+InvalidActiveXStateExceptionSystem.Xml.Schema.XmlSchemaExceptionSystem.Xml.XmlExceptionSystem.Xml.XPath.XPathExceptionSystem.Xml.Xsl.XsltCompileExceptionSystem.Xml.Xsl.XsltException

Posted in .NET, programming | Leave a comment

>Every Build You Break

>”Every Build You Break” – a funny song that Roy Osherove performed the geek classic at Microsoft TechEd 2008 event. He composed this song from the original “Every breath you take”. “Every Build You breakOr Refactoring You makeEvery Mock you … Continue reading

Posted in programming | Leave a comment

>T-SQL: Top N Rows Per Group

>The following will return the top 10 players who hit the most home runs per year since 1990. The key is to calculate the “Home Run Rank” of each player for each year. selectHRRanks.*from(Selectb.yearID, b.PlayerID, sum(b.Hr) asTotalHR,rank() over (partition by … Continue reading

Posted in Data Access, programming | Leave a comment