Updating the Database Wrapper for C#

Sameera Perera Code Snippets, Downloads June 19, 2008 1 Minute

I have made a few updates for my Generic Database Wrapper class. The update contains a bug fix along with several additional methods for supporting DbParameters.

The new source file can be downloaded here. I have also updated the file linked to the original post.

Published by Sameera Perera

My passion is creating great software and building outstanding engineering teams to build them. View all posts by Sameera Perera

Published June 19, 2008

One thought on “Updating the Database Wrapper for C#”

Might be obvious for many , but herewith an example of how-to call stored procedure . I spent couple of hours figuring out how-to get out parameters correctly …

    public bool UpdateProject(string procedureName , ref string msg, string domainName,  
        string projectId ,  string prsUser , string prsPassword  ) 

    { 
        int ret = 1 ;       //assume false 

        try 
        { 

            using (Database db = new Database(_ConnectionString)) 
            { 
                //create command with the procedure name 
                DbCommand cmd = db.GetStoredProcedureCommand(procedureName); 

                //add here in parameters 
                db.AddInParameter(cmd,&quot;@domain_user&quot;, DbType.String, (object)domainName); 
                db.AddInParameter(cmd,      &quot;@project_id&quot;, DbType.Int16, (object)projectId); 
                //add out parameters 
                db.AddInOutParameter(cmd,   &quot;@msg&quot;, DbType.String,  (object)msg); 
                db.AddInOutParameter(cmd,   &quot;@ret&quot;, DbType.Int16,  (object)ret); 

                //execute the actual procedure  
                db.ExecuteNonQuery(cmd);  


                //get the output parameter values from the procedure 
                ret = Int32.Parse( cmd.Parameters[ &quot;@ret&quot; ].Value.ToString()); 
                msg = cmd.Parameters[ &quot;@msg&quot; ].Value.ToString(); 

                //returns true if ret == 0 and false if ret == 1  
                return !System.Convert.ToBoolean((int)ret); 

            } //eof using 
        } //eof try 
        catch (Exception e) 
        { 
            msg = &quot;An error in the application occurred. Report the following error code:mlcv1&quot; + e.Message; 
            return false; 
        } //eof catch 
    }  //eof method

LikeLike

Share this:

Like this:

Related

Published by Sameera Perera

One thought on “Updating the Database Wrapper for C#”

Leave a Reply Cancel reply