public CellSet GetResultForFirstYear()
{
using (var conn = new GlimpseAdomdConnection(connStr))
{
conn.Open();
var cmd = conn.CreateCommand();
cmd.CommandText = "SELECT [Date].[Calendar Year].FirstChild on 0 FROM [Adventure Works];";
return cmd.ExecuteCellSet();
}
}
public CellSet GetResultForFirstYear()
{
using (var conn = new GlimpseAdomdConnection(connStr))
{
conn.Open();
var cmd = conn.CreateCommand();
cmd.CommandText = "SELECT [Date].[Calendar Year].FirstChild on 0 FROM [Adventure Works];";
return(cmd.ExecuteCellSet());
}
}
public void WrapsOpenAndPublishesMessage()
{
var mockPublisher = new Mock <ITimedMessagePublisher>();
var mockConn = new Mock <IAdomdConnection>();
var conn = new GlimpseAdomdConnection(mockConn.Object, mockPublisher.Object);
conn.Open();
mockConn.Verify(p => p.Open(), Times.Once);
mockPublisher.Verify(p => p.EmitStartMessage(It.Is <ConnectionStartedMessage>(s => s.ConnectionId == conn.ConnectionId)), Times.Once);
}
public XmlReader TestExecuteXmlReader()
{
using (var conn = new GlimpseAdomdConnection(connStr))
{
conn.Open();
var cmd = conn.CreateCommand();
cmd.CommandText = @"SELECT {[Measures].[Sales Amount],
[Measures].[Gross Profit Margin]} ON COLUMNS,
{[Product].[Product Model Categories].[Category]} ON ROWS
FROM [Adventure Works]
WHERE ([Sales Territory Country].[United States]);";
return cmd.ExecuteXmlReader();
}
}
public CellSet GetResultForYear(int year)
{
using (var conn = new GlimpseAdomdConnection(connStr))
{
conn.Open();
var cmd = conn.CreateCommand();
cmd.CommandText = "SELECT [Date].[Calendar Year].[StrToMember(@CalendarYear)] on 0 FROM [Adventure Works];";
var parameter = cmd.CreateParameter();
parameter.ParameterName = "CalendarYear";
parameter.Value = "CY 2012";
cmd.Parameters.Add(parameter);
return cmd.ExecuteCellSet();
}
}
public XmlReader TestExecuteXmlReader()
{
using (var conn = new GlimpseAdomdConnection(connStr))
{
conn.Open();
var cmd = conn.CreateCommand();
cmd.CommandText = @"SELECT {[Measures].[Sales Amount],
[Measures].[Gross Profit Margin]} ON COLUMNS,
{[Product].[Product Model Categories].[Category]} ON ROWS
FROM [Adventure Works]
WHERE ([Sales Territory Country].[United States]);";
return(cmd.ExecuteXmlReader());
}
}
public CellSet GetResultForYear(int year)
{
using (var conn = new GlimpseAdomdConnection(connStr))
{
conn.Open();
var cmd = conn.CreateCommand();
cmd.CommandText = "SELECT [Date].[Calendar Year].[StrToMember(@CalendarYear)] on 0 FROM [Adventure Works];";
var parameter = cmd.CreateParameter();
parameter.ParameterName = "CalendarYear";
parameter.Value = "CY 2012";
cmd.Parameters.Add(parameter);
return(cmd.ExecuteCellSet());
}
}
public CellSet GetInternetSalesAmount()
{
using (var conn = new GlimpseAdomdConnection(connStr))
{
conn.Open();
var cmd = conn.CreateCommand();
cmd.CommandText = @"WITH SET [EUROPE] AS '{[Customer].[Country].&[France],
[Customer].[Country].&[Germany],
[Customer].[Country].&[United Kingdom]}'
SELECT Measures.[Internet Sales Amount] ON COLUMNS,
[EUROPE] ON ROWS
FROM [Adventure Works];";
return cmd.ExecuteCellSet();
}
}
public CellSet GetInternetSalesAmount()
{
using (var conn = new GlimpseAdomdConnection(connStr))
{
conn.Open();
var cmd = conn.CreateCommand();
cmd.CommandText = @"WITH SET [EUROPE] AS '{[Customer].[Country].&[France],
[Customer].[Country].&[Germany],
[Customer].[Country].&[United Kingdom]}'
SELECT Measures.[Internet Sales Amount] ON COLUMNS,
[EUROPE] ON ROWS
FROM [Adventure Works];";
return(cmd.ExecuteCellSet());
}
}
public DataTable TestDmv()
{
using (var conn = new GlimpseAdomdConnection(connStr))
{
conn.Open();
var cmd = conn.CreateCommand();
cmd.CommandText = "Select * from $System.discover_object_memory_usage";
DataSet ds = new DataSet {
EnforceConstraints = false
};
ds.Tables.Add();
DataTable dt = ds.Tables[0];
dt.Load(cmd.ExecuteReader());
return(dt);
}
}
public DataTable TestExecuteReader()
{
using (var conn = new GlimpseAdomdConnection(connStr))
{
conn.Open();
var cmd = conn.CreateCommand();
cmd.CommandText = @"SELECT {[Measures].[Sales Amount],
[Measures].[Gross Profit Margin]} ON COLUMNS,
{[Product].[Product Model Categories].[Category]} ON ROWS
FROM [Adventure Works]
WHERE ([Sales Territory Country].[United States]);";
DataSet ds = new DataSet {EnforceConstraints = false};
ds.Tables.Add();
DataTable dt = ds.Tables[0];
dt.Load(cmd.ExecuteReader());
return dt;
}
}
public DataTable TestExecuteReader()
{
using (var conn = new GlimpseAdomdConnection(connStr))
{
conn.Open();
var cmd = conn.CreateCommand();
cmd.CommandText = @"SELECT {[Measures].[Sales Amount],
[Measures].[Gross Profit Margin]} ON COLUMNS,
{[Product].[Product Model Categories].[Category]} ON ROWS
FROM [Adventure Works]
WHERE ([Sales Territory Country].[United States]);";
DataSet ds = new DataSet {
EnforceConstraints = false
};
ds.Tables.Add();
DataTable dt = ds.Tables[0];
dt.Load(cmd.ExecuteReader());
return(dt);
}
}
public DataTable TestDmv()
{
using (var conn = new GlimpseAdomdConnection(connStr))
{
conn.Open();
var cmd = conn.CreateCommand();
cmd.CommandText = "Select * from $System.discover_object_memory_usage";
DataSet ds = new DataSet { EnforceConstraints = false };
ds.Tables.Add();
DataTable dt = ds.Tables[0];
dt.Load(cmd.ExecuteReader());
return dt;
}
}
public void WrapsOpenAndPublishesMessage()
{
var mockPublisher = new Mock<ITimedMessagePublisher>();
var mockConn = new Mock<IAdomdConnection>();
var conn = new GlimpseAdomdConnection(mockConn.Object, mockPublisher.Object);
conn.Open();
mockConn.Verify(p => p.Open(), Times.Once);
mockPublisher.Verify(p => p.EmitStartMessage(It.Is<ConnectionStartedMessage>(s => s.ConnectionId == conn.ConnectionId)), Times.Once);
}