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