public Form1()
{
InitializeComponent();
ClickHouseQueryProvider provider =// new ClickHouseQueryProvider(CreateConnection(), null, null);
new ClickHouseQueryProvider(
"Async=\"False\";BufferSize=\"4096\";ApacheBufferSize=\"0\";SocketTimeout=\"1000\";" +
"ConnectionTimeout=\"1000\";DataTransferTimeout=\"1000\";KeepAliveTimeout=\"1000\";TimeToLiveMillis=\"0\";" +
"DefaultMaxPerRoute=\"0\";MaxTotal=\"0\";Host=\"10.200.101.163\";Database=\"Northwind\";Port=\"9000\";MaxCompressBufferSize=\"0\";" +
"MaxParallelReplicas=\"0\";Priority=\"0\";Compress=\"True\";CheckCompressedHash=\"True\";Decompress=\"False\";" +
"Extremes=\"False\";MaxThreads=\"0\";MaxExecutionTime=\"0\";MaxBlockSize=\"0\";MaxRowsToGroupBy=\"0\";" +
"User=\"default\";Password=\"\";DistributedAggregationMemoryEfficient=\"False\";MaxBytesBeforeExternalGroupBy=\"0\";" +
"MaxBytesBeforeExternalSort=\"0\"", null, null);
col = new lineorder_flat_collection(provider);
// var query = (IQueryable<lineorder_flat>)
// from lineOrder in flat_Collection.FlatCollection
// select lineOrder;
//var me = this
//var fact_code = .GetObjectsQuery<lineorder_flat_collection>(false);
//// ObjectsQuery fact_code = new ObjectsQuery()
//var query =
// from fact in fact_code
// select new FactLS
// {
// Date = fact.Date,
// Contract = fact.Contract,
// Summ = fact.Summ,
// Order = fact.Order,
// Article = fact.Article
// };
// linqServerModeSource1.KeyExpression = "LO_ORDERKEY";
// this.pivotGridControl1.OptionsData.DataProcessingEngine = DevExpress.XtraPivotGrid.PivotDataProcessingEngine.Legacy;
}
private static DbEntityProvider CreateNorthwindProvider()
{
var provider = new ClickHouseQueryProvider(
"Async=\"False\";BufferSize=\"4096\";ApacheBufferSize=\"0\";SocketTimeout=\"1000\";" +
"ConnectionTimeout=\"1000\";DataTransferTimeout=\"1000\";KeepAliveTimeout=\"1000\";TimeToLiveMillis=\"0\";" +
"DefaultMaxPerRoute=\"0\";MaxTotal=\"0\";Host=\"10.200.101.163\";Database=\"Northwind\";Port=\"9000\";MaxCompressBufferSize=\"0\";" +
"MaxParallelReplicas=\"0\";Priority=\"0\";Compress=\"True\";CheckCompressedHash=\"True\";Decompress=\"False\";" +
"Extremes=\"False\";MaxThreads=\"0\";MaxExecutionTime=\"0\";MaxBlockSize=\"0\";MaxRowsToGroupBy=\"0\";" +
"User=\"default\";Password=\"\";DistributedAggregationMemoryEfficient=\"False\";MaxBytesBeforeExternalGroupBy=\"0\";" +
"MaxBytesBeforeExternalSort=\"0\"",
//"Async=\"False\";BufferSize=\"4096\";ApacheBufferSize=\"0\";SocketTimeout=\"1000\";" +
//"ConnectionTimeout=\"1000\";DataTransferTimeout=\"1000\";KeepAliveTimeout=\"1000\";TimeToLiveMillis=\"0\";"+
//"DefaultMaxPerRoute=\"0\";MaxTotal=\"0\";Host=\"localhost\";Database=\"Northwind\";Port=\"32769\";MaxCompressBufferSize=\"0\";" +
//"MaxParallelReplicas=\"0\";Priority=\"0\";Compress=\"True\";CheckCompressedHash=\"True\";Decompress=\"False\";"+
//"Extremes=\"False\";MaxThreads=\"0\";MaxExecutionTime=\"0\";MaxBlockSize=\"0\";MaxRowsToGroupBy=\"0\";" +
//"User=\"default\";Password=\"\";DistributedAggregationMemoryEfficient=\"False\";MaxBytesBeforeExternalGroupBy=\"0\";"+
//"MaxBytesBeforeExternalSort=\"0\"",
//"Server=localhost;user id='root';password='******';Database=Northwind",
new AttributeMapping(typeof(Test.NorthwindWithAttributes)));
provider.Log = System.Console.Out;
return(provider);
}
