ADOMD.NET的参数查询

OLE DB 还是 ADOMD.NET,

肯定是后者，它支持参数查询

using System;using System.Data.OleDb; class Program { static void Main() { string connectionString =@"Provider=MSOLAP;Data Source=localhost;Catalog=AdventureWorks Tabular Model SQL 2012"; string queryString = @"EVALUATECALCULATETABLE( VALUES('Product Subcategory'[Product Subcategory Name]), 'Product Category'[Product Category Name] = @Category )"; using (var connection = new OleDbConnection(connectionString)) { connection.Open(); using (var command = new OleDbCommand(queryString, connection)) { command.Parameters.AddWithValue("@Category", "Bikes"); using (var reader = command.ExecuteReader()) { while (reader.Read()) { Console.WriteLine(reader[0]); } } } } }}