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]);                    }                }            }        }    }}