SqlException.cs 4.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176
  1. //
  2. // System.Data.SqlClient.SqlException.cs
  3. //
  4. // Author:
  5. // Rodrigo Moya ([email protected])
  6. // Daniel Morgan ([email protected])
  7. // Tim Coleman ([email protected])
  8. //
  9. // (C) Ximian, Inc
  10. // Copyright (C) Tim Coleman, 2002
  11. //
  12. //
  13. // Copyright (C) 2004 Novell, Inc (http://www.novell.com)
  14. //
  15. // Permission is hereby granted, free of charge, to any person obtaining
  16. // a copy of this software and associated documentation files (the
  17. // "Software"), to deal in the Software without restriction, including
  18. // without limitation the rights to use, copy, modify, merge, publish,
  19. // distribute, sublicense, and/or sell copies of the Software, and to
  20. // permit persons to whom the Software is furnished to do so, subject to
  21. // the following conditions:
  22. //
  23. // The above copyright notice and this permission notice shall be
  24. // included in all copies or substantial portions of the Software.
  25. //
  26. // THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND,
  27. // EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF
  28. // MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND
  29. // NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE
  30. // LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION
  31. // OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION
  32. // WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
  33. //
  34. using System;
  35. using System.ComponentModel;
  36. using System.Data;
  37. using System.Data.Common;
  38. using System.Runtime.Serialization;
  39. using System.Text;
  40. using Mono.Data.Tds.Protocol;
  41. namespace System.Data.SqlClient
  42. {
  43. [Serializable]
  44. public sealed class SqlException
  45. #if NET_2_0
  46. : DbException
  47. #else
  48. : SystemException
  49. #endif //NET_1_1
  50. {
  51. #region Fields
  52. private readonly SqlErrorCollection errors;
  53. private const string DEF_MESSAGE = "SQL Exception has occured.";
  54. #endregion // Fields
  55. #region Constructors
  56. internal SqlException ()
  57. : this (DEF_MESSAGE, null, null)
  58. {
  59. }
  60. internal SqlException (string message, Exception inner)
  61. : this (message, inner, null)
  62. {
  63. }
  64. internal SqlException (string message, Exception inner, SqlError sqlError)
  65. : base (message == null ? DEF_MESSAGE : message, inner)
  66. {
  67. HResult = -2146232060;
  68. errors = new SqlErrorCollection ();
  69. if (sqlError != null)
  70. errors.Add (sqlError);
  71. }
  72. internal SqlException (byte theClass, int lineNumber, string message, int number, string procedure, string server, string source, byte state)
  73. : this (null,
  74. null,
  75. new SqlError (theClass, lineNumber, message,
  76. number, procedure, server, source,
  77. state))
  78. {
  79. }
  80. private SqlException(SerializationInfo si, StreamingContext sc)
  81. {
  82. HResult = -2146232060;
  83. errors = (SqlErrorCollection) si.GetValue ("Errors", typeof (SqlErrorCollection));
  84. }
  85. #endregion // Constructors
  86. #region Properties
  87. public byte Class {
  88. get { return Errors [0].Class; }
  89. }
  90. [DesignerSerializationVisibility (DesignerSerializationVisibility.Content)]
  91. public SqlErrorCollection Errors {
  92. get { return errors; }
  93. }
  94. public int LineNumber {
  95. get { return Errors [0].LineNumber; }
  96. }
  97. public override string Message {
  98. get {
  99. if (Errors.Count == 0)
  100. return base.Message;
  101. StringBuilder result = new StringBuilder ();
  102. if (base.Message != DEF_MESSAGE) {
  103. result.Append (base.Message);
  104. result.Append ("\n");
  105. }
  106. for (int i = 0; i < Errors.Count -1; i++) {
  107. result.Append (Errors [i].Message);
  108. result.Append ("\n");
  109. }
  110. result.Append (Errors [Errors.Count - 1].Message);
  111. return result.ToString ();
  112. }
  113. }
  114. public int Number {
  115. get { return Errors [0].Number; }
  116. }
  117. public string Procedure {
  118. get { return Errors [0].Procedure; }
  119. }
  120. public string Server {
  121. get { return Errors [0].Server; }
  122. }
  123. public override string Source {
  124. get { return Errors [0].Source; }
  125. }
  126. public byte State {
  127. get { return Errors [0].State; }
  128. }
  129. #endregion // Properties
  130. #region Methods
  131. internal static SqlException FromTdsInternalException (TdsInternalException e)
  132. {
  133. SqlError sqlError = new SqlError (e.Class, e.LineNumber, e.Message,
  134. e.Number, e.Procedure, e.Server,
  135. "Mono SqlClient Data Provider", e.State);
  136. return new SqlException (null, e, sqlError);
  137. }
  138. public override void GetObjectData (SerializationInfo si, StreamingContext context)
  139. {
  140. if (si == null)
  141. throw new ArgumentNullException ("si");
  142. si.AddValue ("Errors", errors, typeof(SqlErrorCollection));
  143. base.GetObjectData (si, context);
  144. }
  145. #endregion // Methods
  146. }
  147. }