public AdomdDataReader ExecuteReader() { if (_obj != null) { _obj.Parameters.Clear(); foreach (AdomdParameter param in _parameters) { _obj.Parameters.Add(new AsAdomdClient.AdomdParameter(param.Name, param.Value)); } return(new AdomdDataReader(_obj.ExecuteReader())); } else { ExcelAdoMdConnections.ReturnDelegate <AdomdDataReader> f = delegate { _objExcel.Parameters.Clear(); foreach (AdomdParameter param in _parameters) { _objExcel.Parameters.Add(new ExcelAdomdClient.AdomdParameter(param.Name, param.Value)); } return(new AdomdDataReader(_objExcel.ExecuteReader())); }; return(f()); } }
public ADOMD.AdomdDataReader ExecuteReader(string qry, ADOMD.AdomdConnection cnn) { var cmd = new ADOMD.AdomdCommand(qry, cnn); ADOMD.AdomdDataReader reader = cmd.ExecuteReader(); return(reader); }
internal MiningValueCollectionInternal(MiningModelColumn column) { this.internalObjectCollection = new ArrayList(); if (column.IsTable) { return; } AdomdCommand adomdCommand = new AdomdCommand(); adomdCommand.CommandText = string.Format(CultureInfo.InvariantCulture, "SELECT DISTINCT {0} FROM [{1}]", new object[] { column.FullyQualifiedName, column.ParentMiningModel.Name }); adomdCommand.Connection = column.ParentMiningModel.ParentConnection; AdomdDataReader adomdDataReader = adomdCommand.ExecuteReader(); int num = -1; while (adomdDataReader.Read()) { num++; object objValue = adomdDataReader[0]; string content = column.Content; MiningValueType valueType = MiningValueType.Missing; if (num == 0 && content.IndexOf("key", StringComparison.OrdinalIgnoreCase) < 0) { valueType = MiningValueType.Missing; } else if (string.Compare(content, "discrete", StringComparison.OrdinalIgnoreCase) == 0 || string.Compare(content, "key", StringComparison.OrdinalIgnoreCase) == 0) { valueType = MiningValueType.Discrete; } else if (content.IndexOf("discretized", StringComparison.OrdinalIgnoreCase) == 0) { valueType = MiningValueType.Discretized; } else if (string.Compare(content, "continuous", StringComparison.OrdinalIgnoreCase) == 0) { valueType = MiningValueType.Continuous; } MiningValue newValue = new MiningValue(valueType, num, objValue); this.Add(newValue); } adomdDataReader.Close(); adomdDataReader.Dispose(); adomdCommand.Dispose(); }
private void LoadExistingMemoryDimensionSignatures() { Microsoft.AnalysisServices.AdomdServer.Context.TraceEvent(0, 1, "Starting LoadExistingMemoryDimensionSignatures"); //retrieve all the existing dimension members AdomdClient.AdomdCommand cmd = new AdomdClient.AdomdCommand("with member [Measures].[Must Have A Measure] as null select [Measures].[Must Have A Measure] on 0, Leaves([Memory]) properties MEMBER_CAPTION, [Memory].[Memory Name].[Key0] on 1 from [$Memory]"); try { cmd.Connection = new AdomdClient.AdomdConnection("Data Source=" + AdomdServer.Context.CurrentServerID + ";Initial Catalog=" + DATABASE_NAME); cmd.Connection.Open(); cmd.Properties.Add("ReturnCellProperties", true); AdomdClient.AdomdDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { if (!Convert.IsDBNull(dr["[Memory].[Memory Name].[Memory Name].[Key]"])) //SSAS Unknown member will have null key { DateTime dt; string signature = ObjToString(dr["[Memory].[Memory Name].[Memory Name].[MEMBER_CAPTION]"]) + "\r\n" + ObjToString(dr["[Memory].[User].[User].[MEMBER_CAPTION]"]) + "\r\n" + (string.IsNullOrEmpty(ObjToString(dr["[Memory].[Creation Time].[Creation Time].[MEMBER_CAPTION]"])) || !DateTime.TryParse(Convert.ToString(dr["[Memory].[Creation Time].[Creation Time].[MEMBER_CAPTION]"]), out dt) ? "" : Convert.ToDateTime(dr["[Memory].[Creation Time].[Creation Time].[MEMBER_CAPTION]"]).ToString("s")) + "\r\n" + ObjToString(dr["[Memory].[Shrinkable].[Shrinkable].[MEMBER_CAPTION]"]) + "\r\n" + ObjToString(dr["[Memory].[Folder 1].[Folder 1].[MEMBER_CAPTION]"]) + "\r\n" + ObjToString(dr["[Memory].[Level 1].[Level 1].[MEMBER_CAPTION]"]) + "\r\n" + ObjToString(dr["[Memory].[Folder 2].[Folder 2].[MEMBER_CAPTION]"]) + "\r\n" + ObjToString(dr["[Memory].[Level 2].[Level 2].[MEMBER_CAPTION]"]) + "\r\n" + ObjToString(dr["[Memory].[Folder 3].[Folder 3].[MEMBER_CAPTION]"]) + "\r\n" + ObjToString(dr["[Memory].[Level 3].[Level 3].[MEMBER_CAPTION]"]) + "\r\n" + ObjToString(dr["[Memory].[Folder 4].[Folder 4].[MEMBER_CAPTION]"]) + "\r\n" + ObjToString(dr["[Memory].[Level 4].[Level 4].[MEMBER_CAPTION]"]) + "\r\n" + ObjToString(dr["[Memory].[File Extension].[File Extension].[MEMBER_CAPTION]"]); long key = Convert.ToInt64(dr["[Memory].[Memory Name].[Memory Name].[Key]"]); if (!dictExistingMemoryRowID.ContainsKey(signature)) { dictExistingMemoryRowID.Add(signature, key); } } } dr.Close(); } catch { Microsoft.AnalysisServices.AdomdServer.Context.TraceEvent(0, 2, "Caught error in LoadExistingMemoryDimensionSignatures"); } finally { try { cmd.Connection.Close(); } catch { } } Microsoft.AnalysisServices.AdomdServer.Context.TraceEvent(0, 3, "Finishing LoadExistingMemoryDimensionSignatures"); }
/* * Return results from query */ public AdomdDataReader GetQueryResult(string sQuery) { try { string sConnString = "Data Source=" + sServer + "; Initial Catalog=" + sCatalog; Microsoft.AnalysisServices.AdomdClient.AdomdConnection objConn = new Microsoft.AnalysisServices.AdomdClient.AdomdConnection(sConnString); objConn.Open(); Microsoft.AnalysisServices.AdomdClient.AdomdCommand objCmd = objConn.CreateCommand(); objCmd.CommandText = sQuery; //Microsoft.AnalysisServices.AdomdClient.AdomdDataReader objReader = objCmd.ExecuteReader(); //Microsoft.AnalysisServices.AdomdClient.AdomdDataAdapter objDataAdaptor = new Microsoft.AnalysisServices.AdomdClient.AdomdDataAdapter(objCmd); Microsoft.AnalysisServices.AdomdClient.AdomdDataReader objDataReader = objCmd.ExecuteReader(CommandBehavior.CloseConnection); /* * try * { * for (int i = 0; i < objDataReader.FieldCount; i++) * { * Console.Write(objDataReader.GetName(i) + "\t"); * } * Console.WriteLine(); * while (objDataReader.Read()) * { * for (int i = 0; i < objDataReader.FieldCount; i++) * { * object value = objDataReader.GetValue(i); * string strValue = (value == null) ? * string.Empty : value.ToString(); * Console.Write(strValue + "\t"); * } * Console.WriteLine(); * } * } * finally * { * objDataReader.Close(); * } */ return(objDataReader); } catch (Exception e) { Console.WriteLine(e.StackTrace); } return(null); }