Debugger Tips and Tricks

DebuggerDisplayAttribute wird auf jeden Fall ab heutigem Tage verwendet!! DebuggerBrowsable und DebuggerStepThrough finde ich jetzt nicht so interessant. F11 und F10 und vor allem Shift+F10 in Visual Studio helfen viel weiter. Siehe Artikel: Visual Studio Debugger Tips and Tricks: ASP Alliance

Infotext : Wie man Software schnell und GUT produziert MUST READ

How to produce a software product quickly von Jeffrey Palermo [C# MVP] Es gibt auch noch einen ersten Teil. How to produce a software product quickly - PART 1

Call a Oracle function in .net c# with the Enterprise Library Application Block

we got the following function: fnc_get_package_version in the package: PCK_MY_APPLICATION

here is the code to call that function from c# with the Enterprise Library Application Block.

string returnValue = "";
 Database database = this.GetDatabase();

 DbCommand dbCommand = 
    database.GetStoredProcCommand("PCK_MY_APPLICATION.fnc_get_package_version");

 OracleParameter returnParam = new OracleParameter("return", OracleType.VarChar);
 returnParam.Size = 10;
 returnParam.Direction = ParameterDirection.ReturnValue;
 dbCommand.Parameters.Add(returnParam);

 int affected = database.ExecuteNonQuery(dbCommand);
 Debug.WriteLine(
   "affected rows: " + affected + "   returnParam.Value: " + returnParam.Value);

 returnValue = returnParam.Value.ToString();
 dbCommand.Dispose();

 return returnValue;

Latest Posts

Popular Posts