enterprise systems - Page 12

Sparx System Enterprise Architect Book

- by Helton Valentini

Does anyone know if there is a book about Sparx systems Enterprise Architect ? (besides sparx site and reference)

Cannot figure out how to take in generic parameters for an Enterprise Framework library sql statemen

I have written a specialized class to wrap up the enterprise library database functionality for easier usage. The reasoning for using the Enterprise Library is because my applications commonly connect to both oracle and sql server database systems. My wrapper handles both creating connection strings on the fly, connecting, and executing queries allowing my main code to only have to write a few lines of code to do database stuff and deal with error handling. As an example my ExecuteNonQuery method has the following declaration: /// <summary> /// Executes a query that returns no results (e.g. insert or update statements) /// </summary> /// <param name="sqlQuery"></param> /// <param name="parameters">Hashtable containing all the parameters for the query</param> /// <returns>The total number of records modified, -1 if an error occurred </returns> public int ExecuteNonQuery(string sqlQuery, Hashtable parameters) { // Make sure we are connected to the database if (!IsConnected) { ErrorHandler("Attempted to run a query without being connected to a database.", ErrorSeverity.Critical); return -1; } // Form the command DbCommand dbCommand = _database.GetSqlStringCommand(sqlQuery); // Add all the paramters foreach (string key in parameters.Keys) { if (parameters[key] == null) _database.AddInParameter(dbCommand, key, DbType.Object, null); else _database.AddInParameter(dbCommand, key, DbType.Object, parameters[key].ToString()); } return _database.ExecuteNonQuery(dbCommand); } _database is defined as private Database _database;. Hashtable parameters are created via code similar to p.Add("@param", value);. the issue I am having is that it seems that with enterprise library database framework you must declare the dbType of each parameter. This isn't an issue when you are calling the database code directly when forming the paramters but doesn't work for creating a generic abstraction class such as I have. In order to try and get around that I thought I could just use DbType.Object and figure the DB will figure it out based on the columns the sql is working with. Unfortunately, this is not the case as I get the following error: Implicit conversion from data type sql_variant to varchar is not allowed. Use the CONVERT function to run this query Is there any way to use generic parameters in a wrapper class or am I just going to have to move all my DB code into my main classes?

Search Results

Search found 11720 results on 469 pages for 'enterprise systems'.

Page 12/469 | < Previous Page | 8 9 10 11 12 13 14 15 16 17 18 19 | Next Page >

- by Helton Valentini

- by KallDrexx

- by etranger

- by Rohit

- by Rob Young

- by chung.wu

- by gWiz

- by Anand Akela

- by Dain C. Hansen

- by Javier Puerta

- by Alex B.

- by davenewza

- by Mahmoud Hossam

- by nospam(at)example.com (Joerg Moellenkamp)

- by David Lively

- by Keyo

- by Roxana Babiciu

- by Marc Pilgaard

- by Mike Stiles

- by Puckl

- by Maxim Veksler

< Previous Page | 8 9 10 11 12 13 14 15 16 17 18 19 | Next Page >