private static SqlCeDatabase GetDatabase() { SqlCeDatabase db = null; if (!string.IsNullOrEmpty(m_Settings.ConnectionString)) { db = new SqlCeDatabase(m_Settings.ConnectionString); } else { //db = DatabaseFactory.CreateDatabase(); } return db; }
internal static object ExecuteScalarFromSql(SqlCeDatabase database, string query, FieldValue[] fieldValueArray) { SqlCeCommand dbCommand; Object obj = null; dbCommand = database.GetSqlStringCommand(query); if (dbCommand != null) { try { SetCommandProperties(dbCommand); if (fieldValueArray != null && fieldValueArray.Length > 0) { dbCommand.Parameters.AddRange(GetParameters(fieldValueArray)); } obj = database.ExecuteScalar(dbCommand); if (obj is DBNull) { obj = null; } } finally { dbCommand.Dispose(); } } return obj; }
internal static int ExecuteNonQueryFromSql(SqlCeDatabase database, string query, FieldValue[] fieldValueArray) { SqlCeCommand dbCommand; int rtnValue = -1; dbCommand = database.GetSqlStringCommand(query); if (dbCommand != null) { try { SetCommandProperties(dbCommand); if (fieldValueArray != null && fieldValueArray.Length > 0) { dbCommand.Parameters.AddRange(GetParameters(fieldValueArray)); } rtnValue = database.ExecuteNonQuery(dbCommand, false); } finally { dbCommand.Dispose(); } } return rtnValue; }
internal static IDataReader ExecuteReaderFromSql(SqlCeDatabase database, string query, FieldValue[] fieldValueArray) { SqlCeCommand dbCommand; IDataReader rdr = null; dbCommand = database.GetSqlStringCommand(query); if (dbCommand != null) { try { SetCommandProperties(dbCommand); if (fieldValueArray != null && fieldValueArray.Length > 0) { dbCommand.Parameters.AddRange(GetParameters(fieldValueArray)); } rdr = database.ExecuteReader(dbCommand); } finally { dbCommand.Dispose(); } } return rdr; }
internal static SqlCeResultSet ExecuteDataSetFromSql(SqlCeDatabase database, string query, FieldValue[] fieldValueArray) { SqlCeCommand dbCommand; SqlCeResultSet dataSet = null; dbCommand = database.GetSqlStringCommand(query); if (dbCommand != null) { try { SetCommandProperties(dbCommand); if (fieldValueArray != null && fieldValueArray.Length > 0) { dbCommand.Parameters.AddRange(GetParameters(fieldValueArray)); } dataSet = database.ExecuteDataSet(dbCommand); } finally { dbCommand.Dispose(); } } return dataSet; }