1689
1690
1691
1692
1693
1694
1695
1696
1697
1698
1699
1700
1701
1702
1703
1704
1705
1706
1707
1708
1709
1710
1711
1712
1713
1714
1715
1716
1717
1718
1719
1720
1721
1722
1723
1724
1725
1726
1727
1728
1729
1730
1731
1732
1733
1734
1735
1736
1737
1738
1739
1740
1741
1742
1743
1744
1745
1746
1747
1748
1749
1750
1751
1752
1753
1754
1755
1756
1757
1758
1759
1760
1761
1762
1763
1764
1765
1766
1767
1768
1769
1770
1771
1772
1773
1774
1775
1776
1777
1778
1779
1780
1781
1782
1783
1784
1785
1786
1787
1788
1789
1790
1791
1792
1793
1794
1795
1796
1797
1798
1799
1800
1801
1802
1803
1804
1805
1806
1807
1808
1809
1810
1811
1812
1813
1814
1815
1816
1817
1818
1819
1820
1821
1822
1823
1824
1825
1826
1827
1828
1829
1830
1831
1832
1833
1834
1835
1836
1837
1838
1839
1840
1841
1842
1843
1844
1845
1846
1847
1848
1849
1850
1851
1852
1853
1854
1855
1856
1857
1858
1859
1860
1861
1862
1863
1864
1865
1866
1867
1868
1869
1870
1871
1872
1873
1874
1875
1876
1877
1878
1879
1880
1881
1882
1883
1884
1885
1886
1887
1888
1889
1890
1891
1892
1893
1894
1895
1896
1897
1898
1899
1900
1901
1902
1903
1904
1905
1906
1907
1908
1909
1910
1911
1912
1913
1914
1915
1916
1917
1918
1919
1920
1921
1922
1923
1924
1925
1926
1927
1928
1929
1930
1931
1932
1933
1934
1935
1936
1937
1938
1939
1940
1941
1942
1943
1944
1945
1946
1947
1948
1949
1950
1951
1952
1953
1954
1955
1956
1957
1958
1959
1960
1961
1962
1963
1964
1965
1966
1967
1968
1969
1970
1971
1972
1973
1974
1975
1976
1977
1978
1979
1980
1981
1982
1983
1984
1985
1986
1987
1988
1989
1990
1991
1992
1993
1994
1995
1996
1997
1998
1999
2000
2001
2002
2003
2004
2005
2006
2007
2008
2009
2010
2011
2012
2013
2014
2015
2016
2017
2018
2019
2020
2021
2022
2023
2024
2025
2026
2027
2028
2029
2030
2031
2032
2033
2034
2035
2036
2037
2038
2039
2040
2041
2042
2043
2044
2045
2046
2047
2048
2049
2050
2051
2052
2053
2054
2055
2056
2057
2058
2059
2060
2061
2062
2063
2064
2065
2066
2067
2068
2069
2070
2071
2072
2073
2074
2075
2076
2077
2078
2079
2080
2081
2082
2083
2084
2085
2086
2087
2088
2089
2090
2091
2092
2093
2094
2095
2096
2097
2098
2099
2100
2101
2102
2103
2104
2105
2106
2107
2108
2109
2110
2111
2112
2113
2114
2115
2116
2117
2118
2119
2120
2121
2122
2123
2124
2125
2126
2127
2128
2129
2130
2131
2132
2133
2134
2135
2136
2137
2138
2139
2140
2141
2142
2143
2144
2145
2146
2147
2148
2149
2150
2151
2152
2153
2154
2155
2156
2157
2158
2159
2160
2161
2162
2163
2164
2165
2166
2167
2168
2169
2170
2171
2172
2173
2174
2175
2176
2177
2178
2179
2180
2181
2182
2183
2184
2185
2186
2187
2188
2189
2190
2191
2192
2193
2194
2195
2196
2197
2198
2199
2200
2201
2202
2203
2204
2205
2206
2207
2208
2209
2210
2211
2212
2213
2214
2215
2216
2217
2218
2219
2220
2221
2222
2223
2224
2225
2226
2227
2228
2229
2230
2231
2232
2233
2234
2235
2236
2237
2238
2239
2240
2241
2242
2243
2244
2245
2246
2247
2248
2249
2250
2251
2252
2253
2254
2255
2256
2257
2258
2259
2260
2261
2262
2263
2264
2265
2266
2267
2268
2269
2270
2271
2272
2273
2274
2275
2276
2277
2278
2279
2280
2281
2282
2283
2284
2285
2286
2287
2288
2289
2290
2291
2292
2293
2294
2295
2296
2297
2298
2299
2300
2301
2302
2303
2304
2305
2306
2307
2308
2309
2310
2311
2312
2313
2314
2315
2316
2317
2318
2319
2320
2321
2322
2323
2324
2325
2326
2327
2328
2329
2330
2331
2332
2333
2334
2335
2336
2337
2338
2339
2340
2341
2342
2343
2344
2345
2346
2347
2348
2349
2350
2351
2352
2353
2354
2355
2356
2357
2358
2359
2360
2361
2362
2363
2364
2365
2366
2367
2368
2369
2370
2371
2372
2373
2374
2375
2376
2377
2378
2379
2380
2381
2382
2383
2384
2385
2386
2387
2388
2389
2390
2391
2392
2393
2394
2395
2396
2397
2398
2399
2400
2401
2402
2403
2404
2405
2406
2407
2408
2409
2410
2411
2412
2413
2414
2415
2416
2417
2418
2419
2420
2421
2422
2423
2424
2425
2426
2427
2428
2429
2430
2431
2432
2433
2434
2435
2436
2437
2438
2439
2440
2441
2442
2443
2444
2445
2446
2447
2448
2449
2450
2451
2452
2453
2454
2455
2456
2457
2458
2459
2460
2461
2462
2463
2464
2465
2466
2467
2468
2469
2470
2471
2472
2473
2474
2475
2476
2477
2478
2479
2480
2481
2482
2483
2484
2485
2486
2487
2488
2489
2490
2491
2492
2493
2494
2495
2496
2497
2498
2499
2500
2501
2502
2503
2504
2505
2506
2507
2508
2509
2510
2511
2512
2513
2514
2515
2516
2517
2518
2519
2520
2521
2522
2523
2524
2525
2526
2527
2528
2529
2530
2531
2532
2533
2534
2535
2536
2537
2538
2539
2540
2541
2542
2543
2544
2545
2546
2547
2548
2549
2550
2551
2552
2553
2554
2555
2556
2557
2558
2559
2560
2561
2562
2563
2564
2565
2566
2567
2568
2569
2570
2571
2572
2573
2574
2575
2576
2577
2578
2579
2580
2581
2582
2583
2584
2585
2586
2587
2588
2589
2590
2591
2592
2593
2594
2595
2596
2597
2598
2599
2600
2601
2602
2603
2604
2605
2606
2607
2608
2609
2610
2611
2612
2613
2614
2615
2616
2617
2618
2619
2620
2621
2622
2623
2624
2625
2626
2627
2628
2629
2630
2631
2632
2633
2634
2635
2636
2637
2638
2639
2640
2641
2642
2643
2644
2645
2646
2647
2648
2649
2650
2651
2652
2653
2654
2655
2656
2657
2658
2659
2660
2661
2662
2663
2664
2665
2666
2667
2668
2669
2670
2671
2672
2673
2674
2675
2676
2677
2678
2679
2680
2681
2682
2683
2684
2685
2686
2687
2688
2689
2690
2691
2692
2693
2694
2695
2696
2697
2698
2699
2700
2701
2702
2703
2704
2705
2706
2707
2708
2709
2710
2711
2712
2713
2714
2715
2716
2717
2718
2719
2720
2721
2722
2723
2724
2725
2726
2727
2728
2729
2730
2731
2732
2733
2734
2735
2736
2737
2738
2739
2740
2741
2742
2743
2744
2745
2746
2747
2748
2749
2750
2751
2752
2753
2754
2755
2756
2757
2758
2759
2760
2761
2762
2763
2764
2765
2766
2767
2768
2769
2770
2771
2772
2773
2774
2775
2776
2777
2778
2779
2780
2781
2782
2783
2784
2785
2786
2787
2788
2789
2790
2791
2792
2793
2794
2795
2796
2797
2798
2799
2800
2801
2802
2803
2804
2805
2806
2807
2808
2809
2810
2811
2812
2813
2814
2815
2816
2817
2818
2819
2820
2821
2822
2823
2824
2825
2826
2827
2828
2829
2830
2831
2832
2833
2834
2835
2836
2837
2838
2839
2840
2841
2842
2843
2844
2845
2846
2847
2848
2849
2850
2851
2852
2853
2854
2855
2856
2857
2858
2859
2860
2861
2862
2863
2864
2865
2866
2867
2868
2869
2870
2871
2872
2873
2874
2875
2876
2877
2878
2879
2880
2881
2882
2883
2884
2885
2886
2887
2888
2889
2890
2891
2892
2893
2894
2895
2896
2897
2898
2899
2900
2901
2902
2903
2904
2905
2906
2907
2908
2909
2910
2911
2912
2913
2914
2915
2916
2917
2918
2919
2920
2921
2922
2923
2924
2925
2926
2927
2928
2929
2930
2931
2932
2933
2934
2935
2936
2937
2938
2939
2940
2941
2942
2943
2944
2945
2946
2947
2948
2949
2950
2951
2952
2953
2954
2955
2956
2957
2958
2959
2960
2961
2962
2963
2964
2965
2966
2967
2968
2969
2970
2971
2972
2973
2974
2975
2976
2977
2978
2979
2980
2981
2982
2983
2984
2985
2986
2987
2988
2989
2990
2991
2992
2993
2994
2995
2996
2997
2998
2999
3000
3001
3002
3003
3004
3005
3006
3007
3008
3009
3010
3011
3012
3013
3014
3015
3016
3017
3018
3019
3020
3021
3022
3023
3024
3025
3026
3027
3028
3029
3030
3031
3032
3033
3034
3035
3036
3037
3038
3039
3040
3041
3042
3043
3044
3045
3046
3047
3048
3049
3050
3051
3052
3053
3054
3055
3056
3057
3058
3059
3060
3061
3062
3063
3064
3065
3066
3067
3068
3069
3070
3071
3072
3073
3074
3075
3076
3077
3078
3079
3080
3081
3082
3083
3084
3085
3086
3087
3088
3089
3090
3091
3092
3093
3094
3095
3096
3097
3098
3099
3100
3101
3102
3103
3104
3105
3106
3107
3108
3109
3110
3111
3112
3113
3114
3115
3116
3117
3118
3119
3120
3121
3122
3123
3124
3125
3126
3127
3128
3129
3130
3131
3132
3133
3134
3135
3136
3137
3138
3139
3140
3141
3142
3143
3144
3145
3146
3147
3148
3149
3150
3151
3152
3153
3154
3155
3156
3157
3158
3159
3160
3161
3162
3163
3164
3165
3166
3167
3168
3169
3170
3171
3172
3173
3174
3175
3176
3177
3178
3179
3180
3181
3182
3183
3184
3185
3186
3187
3188
3189
3190
3191
3192
3193
3194
3195
3196
3197
3198
3199
3200
3201
3202
3203
3204
3205
3206
3207
3208
3209
3210
3211
3212
3213
3214
3215
3216
3217
3218
3219
3220
3221
3222
3223
3224
3225
3226
3227
3228
3229
3230
3231
3232
3233
3234
3235
3236
3237
3238
3239
3240
3241
3242
3243
3244
3245
3246
3247
3248
3249
3250
3251
3252
3253
3254
3255
3256
3257
3258
3259
3260
3261
3262
3263
3264
3265
3266
3267
3268
3269
3270
3271
3272
3273
3274
3275
3276
3277
3278
3279
3280
3281
3282
3283
3284
3285
3286
3287
3288
3289
3290
3291
3292
3293
3294
3295
3296
3297
3298
3299
3300
3301
3302
3303
3304
3305
3306
3307
3308
3309
3310
3311
3312
3313
3314
3315
3316
3317
3318
3319
3320
3321
3322
3323
3324
3325
3326
3327
3328
3329
3330
3331
3332
3333
3334
3335
3336
3337
3338
3339
3340
3341
3342
3343
3344
3345
3346
3347
3348
3349
3350
3351
3352
3353
3354
3355
3356
3357
3358
3359
3360
3361
3362
3363
3364
3365
3366
3367
3368
3369
3370
3371
3372
3373
3374
3375
3376
3377
3378
3379
3380
3381
3382
3383
3384
3385
3386
3387
3388
3389
3390
3391
3392
3393
3394
3395
3396
3397
3398
3399
3400
3401
3402
3403
3404
3405
3406
3407
3408
3409
3410
3411
3412
3413
3414
3415
3416
3417
3418
3419
3420
3421
3422
3423
3424
3425
3426
3427
3428
3429
3430
3431
3432
3433
3434
3435
3436
3437
3438
3439
3440
3441
3442
3443
3444
3445
3446
3447
3448
3449
3450
3451
3452
3453
3454
3455
3456
3457
3458
3459
3460
3461
3462
3463
3464
3465
3466
3467
3468
3469
3470
3471
3472
3473
3474
3475
3476
3477
3478
3479
3480
3481
3482
3483
3484
3485
3486
3487
3488
3489
3490
3491
3492
3493
3494
3495
3496
3497
3498
3499
3500
3501
3502
3503
3504
3505
3506
3507
3508
3509
3510
3511
3512
3513
3514
3515
3516
3517
3518
3519
3520
3521
3522
3523
3524
3525
3526
3527
3528
3529
3530
3531
3532
3533
3534
3535
3536
3537
3538
3539
3540
3541
3542
3543
3544
3545
3546
3547
3548
3549
3550
3551
3552
3553
3554
3555
3556
3557
3558
3559
3560
3561
3562
3563
3564
3565
3566
3567
3568
3569
3570
3571
3572
3573
3574
3575
3576
3577
3578
3579
3580
3581
3582
3583
3584
3585
3586
3587
3588
3589
3590
3591
3592
3593
3594
3595
3596
3597
3598
3599
3600
3601
3602
3603
3604
3605
3606
3607
3608
3609
3610
3611
3612
3613
3614
3615
3616
3617
3618
3619
3620
3621
3622
3623
3624
3625
3626
3627
3628
3629
3630
3631
3632
3633
3634
3635
3636
3637
3638
3639
3640
3641
3642
3643
3644
3645
3646
3647
3648
3649
3650
3651
3652
3653
3654
3655
3656
3657
3658
3659
3660
3661
3662
3663
3664
3665
3666
3667
3668
3669
3670
3671
3672
3673
3674
3675
3676
3677
3678
3679
3680
3681
3682
3683
3684
3685
3686
3687
3688
3689
3690
3691
3692
3693
3694
3695
3696
3697
3698
3699
3700
3701
3702
3703
3704
3705
3706
3707
3708
3709
3710
3711
3712
3713
3714
3715
3716
3717
3718
3719
3720
3721
3722
3723
3724
3725
3726
3727
3728
3729
3730
3731
3732
3733
3734
3735
3736
3737
3738
3739
3740
3741
3742
3743
3744
3745
3746
3747
3748
3749
3750
3751
3752
3753
3754
3755
3756
3757
3758
3759
3760
3761
3762
3763
3764
3765
3766
3767
3768
3769
3770
3771
3772
3773
3774
3775
3776
3777
3778
3779
3780
3781
3782
3783
3784
3785
3786
3787
3788
3789
3790
3791
3792
3793
3794
3795
3796
3797
3798
3799
3800
3801
3802
3803
3804
3805
3806
3807
3808
3809
3810
3811
3812
3813
3814
3815
3816
3817
3818
3819
3820
3821
3822
3823
3824
3825
3826
3827
3828
3829
3830
3831
3832
3833
3834
3835
3836
3837
3838
3839
3840
3841
3842
3843
3844
3845
3846
3847
3848
3849
3850
3851
3852
3853
3854
3855
3856
3857
3858
3859
3860
3861
3862
3863
3864
3865
3866
3867
3868
3869
3870
3871
3872
3873
3874
3875
3876
3877
3878
3879
3880
3881
3882
3883
3884
3885
3886
3887
3888
3889
3890
3891
3892
3893
3894
3895
3896
3897
3898
3899
3900
3901
3902
3903
3904
3905
3906
3907
3908
3909
3910
3911
3912
3913
3914
3915
3916
3917
3918
3919
3920
3921
3922
3923
3924
3925
3926
3927
3928
3929
3930
3931
3932
3933
3934
3935
3936
3937
3938
3939
3940
3941
3942
3943
3944
3945
3946
3947
3948
3949
3950
3951
3952
3953
3954
3955
3956
3957
3958
3959
3960
3961
3962
3963
3964
3965
3966
3967
3968
3969
3970
3971
3972
3973
3974
3975
3976
3977
3978
3979
3980
3981
3982
3983
3984
3985
3986
3987
3988
3989
3990
3991
3992
3993
3994
3995
3996
3997
3998
3999
4000
4001
4002
4003
4004
4005
4006
4007
4008
4009
4010
4011
4012
4013
4014
4015
4016
4017
4018
4019
4020
4021
4022
4023
4024
4025
4026
4027
4028
4029
4030
4031
4032
4033
4034
4035
4036
4037
4038
4039
4040
4041
4042
4043
4044
4045
4046
4047
4048
4049
4050
4051
4052
4053
4054
4055
4056
4057
4058
4059
4060
4061
4062
4063
4064
4065
4066
4067
4068
4069
4070
4071
4072
4073
4074
4075
4076
4077
4078
4079
4080
4081
4082
4083
4084
4085
4086
4087
4088
4089
4090
4091
4092
4093
4094
4095
4096
4097
4098
4099
4100
4101
4102
4103
4104
4105
4106
4107
4108
4109
4110
4111
4112
4113
4114
4115
4116
4117
4118
4119
4120
4121
4122
4123
4124
4125
4126
4127
4128
4129
4130
4131
4132
4133
4134
4135
4136
4137
4138
4139
4140
4141
4142
4143
4144
4145
4146
4147
4148
4149
4150
4151
4152
4153
4154
4155
4156
4157
4158
4159
4160
4161
4162
4163
4164
4165
4166
4167
4168
4169
4170
4171
4172
4173
4174
4175
4176
4177
4178
4179
4180
4181
4182
4183
4184
4185
4186
4187
4188
4189
4190
4191
4192
4193
4194
4195
4196
4197
4198
4199
4200
4201
4202
4203
4204
4205
4206
4207
4208
4209
4210
4211
4212
4213
4214
4215
4216
4217
4218
4219
4220
4221
4222
4223
4224
4225
4226
4227
4228
4229
4230
4231
4232
4233
4234
4235
4236
4237
4238
4239
4240
4241
4242
4243
4244
4245
4246
4247
4248
4249
4250
4251
4252
4253
4254
4255
4256
4257
4258
4259
4260
4261
4262
4263
4264
4265
4266
4267
4268
4269
4270
4271
4272
4273
4274
4275
4276
4277
4278
4279
4280
4281
4282
4283
4284
4285
4286
4287
4288
4289
4290
4291
4292
4293
4294
4295
4296
4297
4298
4299
4300
4301
4302
4303
4304
4305
4306
4307
4308
4309
4310
4311
4312
4313
4314
4315
4316
4317
4318
4319
4320
4321
4322
4323
4324
4325
4326
4327
4328
4329
4330
4331
4332
4333
4334
4335
4336
4337
4338
4339
4340
4341
4342
4343
4344
4345
4346
4347
4348
4349
4350
4351
4352
4353
4354
4355
4356
|
1311
1312
1313
1314
1315
1316
1317
1318
1319
1320
1321
1322
1323
1324
|
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
|
<summary>Returns an approximation of the given geography instance produced by running the Douglas-Peucker algorithm on the instance with the given tolerance.</summary>
<returns>
Returns <see cref="T:System.Data.Entity.Spatial.DbGeometry" />.
</returns>
<param name="geometryValue">The geometry value.</param>
<param name="tolerance">The tolerance to input to the Douglas-Peucker algorithm. tolerance must be a positive number.</param>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlTypesAssemblyLoader.#ctor(System.Data.Entity.SqlServer.SqlTypesAssembly)">
<summary>
Used to create an instance of <see cref="T:System.Data.Entity.SqlServer.SqlTypesAssemblyLoader"/> for a specific SQL Types assembly
such that it can be used for converting EF spatial types backed by one version to those backed by
the version actually in use in this app domain.
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlTypesAssemblyLoader.TryGetSqlTypesAssembly">
<summary>
Returns the highest available version of the Microsoft.SqlServer.Types assembly that could be
located using Assembly.Load; may return <c>null</c> if no version of the assembly could be found.
</summary>
</member>
<member name="T:System.Data.Entity.SqlServer.SqlVersionUtils">
<summary>
This class is a simple utility class that determines the SQL Server version from the
connection.
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlVersionUtils.GetSqlVersion(System.Data.Common.DbConnection)">
<summary>
Get the SqlVersion from the connection. Returns one of Sql8, Sql9, Sql10, Sql11
The passed connection must be open
</summary>
<param name="connection"> current sql connection </param>
<returns> Sql Version for the current connection </returns>
</member>
<member name="T:System.Data.Entity.SqlServer.Utilities.SqlDataReaderWrapper">
<summary>
This is a wrapper for <see cref="T:System.Data.SqlClient.SqlDataReader"/> that allows a mock implementation to be used.
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.Utilities.DbExpressionExtensions.GetLeafNodes(System.Data.Entity.Core.Common.CommandTrees.DbExpression,System.Data.Entity.Core.Common.CommandTrees.DbExpressionKind,System.Func{System.Data.Entity.Core.Common.CommandTrees.DbExpression,System.Collections.Generic.IEnumerable{System.Data.Entity.Core.Common.CommandTrees.DbExpression}})">
<summary>
Uses a stack to non-recursively traverse a given tree structure and retrieve the leaf nodes.
</summary>
<param name="root"> The node that represents the root of the tree. </param>
<param name="kind"> Expressions not of this kind are considered leaves. </param>
<param name="getChildNodes">
A function that traverses the tree by retrieving the <b>immediate</b> descendants of a (non-leaf) node.
</param>
<returns> An enumerable containing the leaf nodes. </returns>
</member>
<member name="T:System.Data.Entity.SqlServer.SqlGen.ISqlFragment">
<summary>
Represents the sql fragment for any node in the query tree.
</summary>
<remarks>
The nodes in a query tree produce various kinds of sql
<list type="bullet">
<item>A select statement.</item>
<item>A reference to an extent. (symbol)</item>
<item>A raw string.</item>
</list>
We have this interface to allow for a common return type for the methods
in the expression visitor <see cref="T:System.Data.Entity.Core.Common.CommandTrees.DbExpressionVisitor`1"/>
Add the endd of translation, the sql fragments are converted into real strings.
</remarks>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.ISqlFragment.WriteSql(System.Data.Entity.SqlServer.SqlGen.SqlWriter,System.Data.Entity.SqlServer.SqlGen.SqlGenerator)">
<summary>
Write the string represented by this fragment into the stream.
</summary>
<param name="writer"> The stream that collects the strings. </param>
<param name="sqlGenerator"> Context information used for renaming. The global lists are used to generated new names without collisions. </param>
</member>
<member name="T:System.Data.Entity.SqlServer.SqlGen.JoinSymbol">
<summary>
A Join symbol is a special kind of Symbol.
It has to carry additional information
<list type="bullet">
<item>
ColumnList for the list of columns in the select clause if this
symbol represents a sql select statement. This is set by
<see cref="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.AddDefaultColumns(System.Data.Entity.SqlServer.SqlGen.SqlSelectStatement)"/>
.
</item>
<item>ExtentList is the list of extents in the select clause.</item>
<item>
FlattenedExtentList - if the Join has multiple extents flattened at the
top level, we need this information to ensure that extent aliases are renamed
correctly in
<see cref="M:System.Data.Entity.SqlServer.SqlGen.SqlSelectStatement.WriteSql(System.Data.Entity.SqlServer.SqlGen.SqlWriter,System.Data.Entity.SqlServer.SqlGen.SqlGenerator)"/>
</item>
<item>
NameToExtent has all the extents in ExtentList as a dictionary.
This is used by
<see cref="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.Visit(System.Data.Entity.Core.Common.CommandTrees.DbPropertyExpression)"/>
to flatten
record accesses.
</item>
<item>
IsNestedJoin - is used to determine whether a JoinSymbol is an
ordinary join symbol, or one that has a corresponding SqlSelectStatement.
</item>
</list>
All the lists are set exactly once, and then used for lookups/enumerated.
</summary>
</member>
<member name="T:System.Data.Entity.SqlServer.SqlGen.Symbol">
<summary>
<see cref="T:System.Data.Entity.SqlServer.SqlGen.SymbolTable"/>
This class represents an extent/nested select statement,
or a column.
The important fields are Name, Type and NewName.
NewName starts off the same as Name, and is then modified as necessary.
The rest are used by special symbols.
e.g. NeedsRenaming is used by columns to indicate that a new name must
be picked for the column in the second phase of translation.
IsUnnest is used by symbols for a collection expression used as a from clause.
This allows <see cref="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.AddFromSymbol(System.Data.Entity.SqlServer.SqlGen.SqlSelectStatement,System.String,System.Data.Entity.SqlServer.SqlGen.Symbol,System.Boolean)"/> to add the column list
after the alias.
</summary>
</member>
<member name="F:System.Data.Entity.SqlServer.SqlGen.Symbol.columns">
<summary>
Used to track the columns originating from this Symbol when it is used
in as a from extent in a SqlSelectStatement with a Join or as a From Extent
in a Join Symbol.
</summary>
</member>
<member name="F:System.Data.Entity.SqlServer.SqlGen.Symbol.outputColumns">
<summary>
Used to track the output columns of a SqlSelectStatement it represents
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.Symbol.#ctor(System.String,System.Data.Entity.Core.Metadata.Edm.TypeUsage,System.Collections.Generic.Dictionary{System.String,System.Data.Entity.SqlServer.SqlGen.Symbol},System.Boolean)">
<summary>
Use this constructor if the symbol represents a SqlStatement for which the output columns need to be tracked.
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.Symbol.WriteSql(System.Data.Entity.SqlServer.SqlGen.SqlWriter,System.Data.Entity.SqlServer.SqlGen.SqlGenerator)">
<summary>
Write this symbol out as a string for sql. This is just
the new name of the symbol (which could be the same as the old name).
We rename columns here if necessary.
</summary>
</member>
<member name="T:System.Data.Entity.SqlServer.SqlGen.OptionalColumn">
<summary>
Represents a column in a select list that should be printed only if it is later used.
Such columns get added by <see cref="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.AddDefaultColumns(System.Data.Entity.SqlServer.SqlGen.SqlSelectStatement)"/>.
The SymbolUsageManager associated with the OptionalColumn has the information whether the column
has been used based on its symbol.
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.OptionalColumn.Append(System.Object)">
<summary>
Append to the "fragment" representing this column
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.OptionalColumn.WriteSqlIfUsed(System.Data.Entity.SqlServer.SqlGen.SqlWriter,System.Data.Entity.SqlServer.SqlGen.SqlGenerator,System.String)">
<summary>
Writes that fragment that represents the optional column
if the usage manager says it is used.
</summary>
</member>
<member name="T:System.Data.Entity.SqlServer.SqlGen.Sql8ConformanceChecker">
<summary>
The Sql8ConformanceChecker walks a DbExpression tree and determines whether
it should be rewritten in order to be translated to SQL appropriate for SQL Server 2000.
The tree should be rewritten if it contains any of the following expressions:
<list type="bullet">
<item>
<see cref="T:System.Data.Entity.Core.Common.CommandTrees.DbExceptExpression"/>
</item>
<item>
<see cref="T:System.Data.Entity.Core.Common.CommandTrees.DbIntersectExpression"/>
</item>
<item>
<see cref="T:System.Data.Entity.Core.Common.CommandTrees.DbSkipExpression"/>
</item>
</list>
Also, it throws if it determines that the tree can not
be translated into SQL appropriate for SQL Server 2000.
This happens if:
<list type="bullet">
<item>
The tree contains
<see cref="T:System.Data.Entity.Core.Common.CommandTrees.DbApplyExpression"/>
</item>
<item>
The tree contains
<see cref="T:System.Data.Entity.Core.Common.CommandTrees.DbLimitExpression"/>
with property Limit of type
<see cref="T:System.Data.Entity.Core.Common.CommandTrees.DbParameterReferenceExpression"/>
</item>
<item>
The tree contains
<see cref="T:System.Data.Entity.Core.Common.CommandTrees.DbSkipExpression"/>
with property Count of type
<see cref="T:System.Data.Entity.Core.Common.CommandTrees.DbParameterReferenceExpression"/>
</item>
</list>
The visitor only checks for expressions for which the support differs between SQL Server 2000 and SQL Server 2005,
but does not check/throw for expressions that are not supported for both providers.
Implementation note: In the cases when the visitor encounters an expression that requires rewrite,
it still needs to walk its structure in case something below it is not supported and needs to throw.
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.Sql8ConformanceChecker.NeedsRewrite(System.Data.Entity.Core.Common.CommandTrees.DbExpression)">
<summary>
The entry point
</summary>
<returns> True if the tree needs to be rewriten, false otherwise </returns>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.Sql8ConformanceChecker.#ctor">
<summary>
Default Constructor
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.Sql8ConformanceChecker.VisitUnaryExpression(System.Data.Entity.Core.Common.CommandTrees.DbUnaryExpression)">
<summary>
Default handling for DbUnaryExpression-derived classes. Simply visits its argument
</summary>
<param name="expr"> The DbUnaryExpression to visit </param>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.Sql8ConformanceChecker.VisitBinaryExpression(System.Data.Entity.Core.Common.CommandTrees.DbBinaryExpression)">
<summary>
Default handling for DbBinaryExpression-derived classes. Visits both arguments.
</summary>
<param name="expr"> The DbBinaryExpression to visit </param>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.Sql8ConformanceChecker.VisitAggregate(System.Data.Entity.Core.Common.CommandTrees.DbAggregate)">
<summary>
Walks the structure
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.Sql8ConformanceChecker.VisitExpressionBinding(System.Data.Entity.Core.Common.CommandTrees.DbExpressionBinding)">
<summary>
DbExpressionBinding handler
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.Sql8ConformanceChecker.VisitExpression(System.Data.Entity.Core.Common.CommandTrees.DbExpression)">
<summary>
Used as handler for expressions
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.Sql8ConformanceChecker.VisitSortClause(System.Data.Entity.Core.Common.CommandTrees.DbSortClause)">
<summary>
Used as handler for SortClauses
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.Sql8ConformanceChecker.VisitList``1(System.Data.Entity.SqlServer.SqlGen.Sql8ConformanceChecker.ListElementHandler{``0},System.Collections.Generic.IList{``0})">
<summary>
Helper method for iterating a list
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.Sql8ConformanceChecker.VisitAggregateList(System.Collections.Generic.IList{System.Data.Entity.Core.Common.CommandTrees.DbAggregate})">
<summary>
Handing for list of <see cref="T:System.Data.Entity.Core.Common.CommandTrees.DbExpressionBinding"/>s.
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.Sql8ConformanceChecker.VisitExpressionBindingList(System.Collections.Generic.IList{System.Data.Entity.Core.Common.CommandTrees.DbExpressionBinding})">
<summary>
Handing for list of <see cref="T:System.Data.Entity.Core.Common.CommandTrees.DbExpressionBinding"/>s.
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.Sql8ConformanceChecker.VisitExpressionList(System.Collections.Generic.IList{System.Data.Entity.Core.Common.CommandTrees.DbExpression})">
<summary>
Handing for list of <see cref="T:System.Data.Entity.Core.Common.CommandTrees.DbExpression"/>s.
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.Sql8ConformanceChecker.VisitSortClauseList(System.Collections.Generic.IList{System.Data.Entity.Core.Common.CommandTrees.DbSortClause})">
<summary>
Handling for list of <see cref="T:System.Data.Entity.Core.Common.CommandTrees.DbSortClause"/>s.
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.Sql8ConformanceChecker.Visit(System.Data.Entity.Core.Common.CommandTrees.DbExpression)">
<summary>
Called when an <see cref="T:System.Data.Entity.Core.Common.CommandTrees.DbExpression"/> of an otherwise unrecognized type is encountered.
</summary>
<param name="expression"> The expression </param>
<exception cref="T:System.NotSupportedException">
Always thrown if this method is called, since it indicates that
<paramref name="expression"/>
is of an unsupported type
</exception>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.Sql8ConformanceChecker.Visit(System.Data.Entity.Core.Common.CommandTrees.DbAndExpression)">
<summary>
<see cref="M:System.Data.Entity.SqlServer.SqlGen.Sql8ConformanceChecker.VisitBinaryExpression(System.Data.Entity.Core.Common.CommandTrees.DbBinaryExpression)"/>
</summary>
<param name="expression"> The DbAndExpression that is being visited. </param>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.Sql8ConformanceChecker.Visit(System.Data.Entity.Core.Common.CommandTrees.DbApplyExpression)">
<summary>
Not supported on SQL Server 2000.
</summary>
<param name="expression"> The DbApplyExpression that is being visited. </param>
<exception cref="T:System.NotSupportedException">Always</exception>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.Sql8ConformanceChecker.Visit(System.Data.Entity.Core.Common.CommandTrees.DbArithmeticExpression)">
<summary>
Default handling for DbArithmeticExpression. Visits all arguments.
</summary>
<param name="expression"> The DbArithmeticExpression that is being visited. </param>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.Sql8ConformanceChecker.Visit(System.Data.Entity.Core.Common.CommandTrees.DbCaseExpression)">
<summary>
Walks the strucutre
</summary>
<param name="expression"> The DbCaseExpression that is being visited. </param>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.Sql8ConformanceChecker.Visit(System.Data.Entity.Core.Common.CommandTrees.DbCastExpression)">
<summary>
<see cref="M:System.Data.Entity.SqlServer.SqlGen.Sql8ConformanceChecker.VisitUnaryExpression(System.Data.Entity.Core.Common.CommandTrees.DbUnaryExpression)"/>
</summary>
<param name="expression"> The DbCastExpression that is being visited. </param>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.Sql8ConformanceChecker.Visit(System.Data.Entity.Core.Common.CommandTrees.DbComparisonExpression)">
<summary>
<see cref="M:System.Data.Entity.SqlServer.SqlGen.Sql8ConformanceChecker.VisitBinaryExpression(System.Data.Entity.Core.Common.CommandTrees.DbBinaryExpression)"/>
</summary>
<param name="expression"> The DbComparisonExpression that is being visited. </param>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.Sql8ConformanceChecker.Visit(System.Data.Entity.Core.Common.CommandTrees.DbConstantExpression)">
<summary>
Returns false
</summary>
<param name="expression"> The DbConstantExpression that is being visited. </param>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.Sql8ConformanceChecker.Visit(System.Data.Entity.Core.Common.CommandTrees.DbCrossJoinExpression)">
<summary>
Walks the structure
</summary>
<param name="expression"> The DbCrossJoinExpression that is being visited. </param>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.Sql8ConformanceChecker.Visit(System.Data.Entity.Core.Common.CommandTrees.DbDerefExpression)">
<summary>
<see cref="M:System.Data.Entity.SqlServer.SqlGen.Sql8ConformanceChecker.VisitUnaryExpression(System.Data.Entity.Core.Common.CommandTrees.DbUnaryExpression)"/>
</summary>
<param name="expression"> The DeRefExpression that is being visited. </param>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.Sql8ConformanceChecker.Visit(System.Data.Entity.Core.Common.CommandTrees.DbDistinctExpression)">
<summary>
<see cref="M:System.Data.Entity.SqlServer.SqlGen.Sql8ConformanceChecker.VisitUnaryExpression(System.Data.Entity.Core.Common.CommandTrees.DbUnaryExpression)"/>
</summary>
<param name="expression"> The DbDistinctExpression that is being visited. </param>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.Sql8ConformanceChecker.Visit(System.Data.Entity.Core.Common.CommandTrees.DbElementExpression)">
<summary>
<see cref="M:System.Data.Entity.SqlServer.SqlGen.Sql8ConformanceChecker.VisitUnaryExpression(System.Data.Entity.Core.Common.CommandTrees.DbUnaryExpression)"/>
</summary>
<param name="expression"> The DbElementExpression that is being visited. </param>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.Sql8ConformanceChecker.Visit(System.Data.Entity.Core.Common.CommandTrees.DbEntityRefExpression)">
<summary>
<see cref="M:System.Data.Entity.SqlServer.SqlGen.Sql8ConformanceChecker.VisitUnaryExpression(System.Data.Entity.Core.Common.CommandTrees.DbUnaryExpression)"/>
</summary>
<param name="expression"> The DbEntityRefExpression that is being visited. </param>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.Sql8ConformanceChecker.Visit(System.Data.Entity.Core.Common.CommandTrees.DbExceptExpression)">
<summary>
Returns true, the tree needs to be rewritten.
</summary>
<param name="expression"> The DbExceptExpression that is being visited. </param>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.Sql8ConformanceChecker.Visit(System.Data.Entity.Core.Common.CommandTrees.DbFilterExpression)">
<summary>
Walks the structure
</summary>
<param name="expression"> The DbFilterExpression that is being visited. </param>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.Sql8ConformanceChecker.Visit(System.Data.Entity.Core.Common.CommandTrees.DbFunctionExpression)">
<summary>
Visits the arguments
</summary>
<param name="expression"> The DbFunctionExpression that is being visited. </param>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.Sql8ConformanceChecker.Visit(System.Data.Entity.Core.Common.CommandTrees.DbLambdaExpression)">
<summary>
Visits the arguments and lambda body
</summary>
<param name="expression"> The DbLambdaExpression that is being visited. </param>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.Sql8ConformanceChecker.Visit(System.Data.Entity.Core.Common.CommandTrees.DbGroupByExpression)">
<summary>
Walks the structure
</summary>
<param name="expression"> The DbExpression that is being visited. </param>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.Sql8ConformanceChecker.Visit(System.Data.Entity.Core.Common.CommandTrees.DbIntersectExpression)">
<summary>
Returns true.
</summary>
<param name="expression"> The DbIntersectExpression that is being visited. </param>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.Sql8ConformanceChecker.Visit(System.Data.Entity.Core.Common.CommandTrees.DbIsEmptyExpression)">
<summary>
<see cref="M:System.Data.Entity.SqlServer.SqlGen.Sql8ConformanceChecker.VisitUnaryExpression(System.Data.Entity.Core.Common.CommandTrees.DbUnaryExpression)"/>
</summary>
<param name="expression"> The DbIsEmptyExpression that is being visited. </param>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.Sql8ConformanceChecker.Visit(System.Data.Entity.Core.Common.CommandTrees.DbIsNullExpression)">
<summary>
<see cref="M:System.Data.Entity.SqlServer.SqlGen.Sql8ConformanceChecker.VisitUnaryExpression(System.Data.Entity.Core.Common.CommandTrees.DbUnaryExpression)"/>
</summary>
<param name="expression"> The DbIsNullExpression that is being visited. </param>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.Sql8ConformanceChecker.Visit(System.Data.Entity.Core.Common.CommandTrees.DbIsOfExpression)">
<summary>
<see cref="M:System.Data.Entity.SqlServer.SqlGen.Sql8ConformanceChecker.VisitUnaryExpression(System.Data.Entity.Core.Common.CommandTrees.DbUnaryExpression)"/>
</summary>
<param name="expression"> The DbIsOfExpression that is being visited. </param>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.Sql8ConformanceChecker.Visit(System.Data.Entity.Core.Common.CommandTrees.DbJoinExpression)">
<summary>
Walks the structure
</summary>
<param name="expression"> The DbJoinExpression that is being visited. </param>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.Sql8ConformanceChecker.Visit(System.Data.Entity.Core.Common.CommandTrees.DbLikeExpression)">
<summary>
Walks the structure
</summary>
<param name="expression"> The DbLikeExpression that is being visited. </param>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.Sql8ConformanceChecker.Visit(System.Data.Entity.Core.Common.CommandTrees.DbLimitExpression)">
<summary>
Walks the structure
</summary>
<exception cref="T:System.NotSupportedException">expression.Limit is DbParameterReferenceExpression</exception>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.Sql8ConformanceChecker.Visit(System.Data.Entity.Core.Common.CommandTrees.DbNewInstanceExpression)">
<summary>
Walks the arguments
</summary>
<param name="expression"> The DbNewInstanceExpression that is being visited. </param>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.Sql8ConformanceChecker.Visit(System.Data.Entity.Core.Common.CommandTrees.DbNotExpression)">
<summary>
<see cref="M:System.Data.Entity.SqlServer.SqlGen.Sql8ConformanceChecker.VisitUnaryExpression(System.Data.Entity.Core.Common.CommandTrees.DbUnaryExpression)"/>
</summary>
<param name="expression"> The DbNotExpression that is being visited. </param>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.Sql8ConformanceChecker.Visit(System.Data.Entity.Core.Common.CommandTrees.DbNullExpression)">
<summary>
Returns false
</summary>
<param name="expression"> The DbNullExpression that is being visited. </param>
<returns> false </returns>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.Sql8ConformanceChecker.Visit(System.Data.Entity.Core.Common.CommandTrees.DbOfTypeExpression)">
<summary>
<see cref="M:System.Data.Entity.SqlServer.SqlGen.Sql8ConformanceChecker.VisitUnaryExpression(System.Data.Entity.Core.Common.CommandTrees.DbUnaryExpression)"/>
</summary>
<param name="expression"> The DbOfTypeExpression that is being visited. </param>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.Sql8ConformanceChecker.Visit(System.Data.Entity.Core.Common.CommandTrees.DbOrExpression)">
<summary>
<see cref="M:System.Data.Entity.SqlServer.SqlGen.Sql8ConformanceChecker.VisitBinaryExpression(System.Data.Entity.Core.Common.CommandTrees.DbBinaryExpression)"/>
</summary>
<param name="expression"> The DbOrExpression that is being visited. </param>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.Sql8ConformanceChecker.Visit(System.Data.Entity.Core.Common.CommandTrees.DbInExpression)">
<summary>
<see cref="T:System.Data.Entity.Core.Common.CommandTrees.DbInExpression"/>
</summary>
<param name="expression"> The DbInExpression that is being visited. </param>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.Sql8ConformanceChecker.Visit(System.Data.Entity.Core.Common.CommandTrees.DbParameterReferenceExpression)">
<summary>
Returns false
</summary>
<param name="expression"> The DbParameterReferenceExpression that is being visited. </param>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.Sql8ConformanceChecker.Visit(System.Data.Entity.Core.Common.CommandTrees.DbProjectExpression)">
<summary>
Walks the structure
</summary>
<param name="expression"> The DbProjectExpression that is being visited. </param>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.Sql8ConformanceChecker.Visit(System.Data.Entity.Core.Common.CommandTrees.DbPropertyExpression)">
<summary>
Returns false
</summary>
<param name="expression"> The DbPropertyExpression that is being visited. </param>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.Sql8ConformanceChecker.Visit(System.Data.Entity.Core.Common.CommandTrees.DbQuantifierExpression)">
<summary>
Walks the structure
</summary>
<param name="expression"> The DbQuantifierExpression that is being visited. </param>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.Sql8ConformanceChecker.Visit(System.Data.Entity.Core.Common.CommandTrees.DbRefExpression)">
<summary>
<see cref="M:System.Data.Entity.SqlServer.SqlGen.Sql8ConformanceChecker.VisitUnaryExpression(System.Data.Entity.Core.Common.CommandTrees.DbUnaryExpression)"/>
</summary>
<param name="expression"> The DbRefExpression that is being visited. </param>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.Sql8ConformanceChecker.Visit(System.Data.Entity.Core.Common.CommandTrees.DbRefKeyExpression)">
<summary>
<see cref="M:System.Data.Entity.SqlServer.SqlGen.Sql8ConformanceChecker.VisitUnaryExpression(System.Data.Entity.Core.Common.CommandTrees.DbUnaryExpression)"/>
</summary>
<param name="expression"> The DbRefKeyExpression that is being visited. </param>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.Sql8ConformanceChecker.Visit(System.Data.Entity.Core.Common.CommandTrees.DbRelationshipNavigationExpression)">
<summary>
Walks the structure
</summary>
<param name="expression"> The DbRelationshipNavigationExpression that is being visited. </param>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.Sql8ConformanceChecker.Visit(System.Data.Entity.Core.Common.CommandTrees.DbScanExpression)">
<summary>
Returns false;
</summary>
<param name="expression"> The DbScanExpression that is being visited. </param>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.Sql8ConformanceChecker.Visit(System.Data.Entity.Core.Common.CommandTrees.DbSkipExpression)">
<summary>
Resturns true
</summary>
<exception cref="T:System.NotSupportedException">expression.Count is DbParameterReferenceExpression</exception>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.Sql8ConformanceChecker.Visit(System.Data.Entity.Core.Common.CommandTrees.DbSortExpression)">
<summary>
Walks the structure
</summary>
<param name="expression"> The DbSortExpression that is being visited. </param>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.Sql8ConformanceChecker.Visit(System.Data.Entity.Core.Common.CommandTrees.DbTreatExpression)">
<summary>
<see cref="M:System.Data.Entity.SqlServer.SqlGen.Sql8ConformanceChecker.VisitUnaryExpression(System.Data.Entity.Core.Common.CommandTrees.DbUnaryExpression)"/>
</summary>
<param name="expression"> The DbTreatExpression that is being visited. </param>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.Sql8ConformanceChecker.Visit(System.Data.Entity.Core.Common.CommandTrees.DbUnionAllExpression)">
<summary>
<see cref="M:System.Data.Entity.SqlServer.SqlGen.Sql8ConformanceChecker.VisitBinaryExpression(System.Data.Entity.Core.Common.CommandTrees.DbBinaryExpression)"/>
</summary>
<param name="expression"> The DbUnionAllExpression that is being visited. </param>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.Sql8ConformanceChecker.Visit(System.Data.Entity.Core.Common.CommandTrees.DbVariableReferenceExpression)">
<summary>
Returns false
</summary>
<param name="expression"> The DbVariableReferenceExpression that is being visited. </param>
<returns> false </returns>
</member>
<member name="T:System.Data.Entity.SqlServer.SqlGen.Sql8ConformanceChecker.ListElementHandler`1">
<summary>
Used for <see cref="M:System.Data.Entity.SqlServer.SqlGen.Sql8ConformanceChecker.VisitList``1(System.Data.Entity.SqlServer.SqlGen.Sql8ConformanceChecker.ListElementHandler{``0},System.Collections.Generic.IList{``0})"/>
</summary>
</member>
<member name="T:System.Data.Entity.SqlServer.SqlGen.Sql8ExpressionRewriter">
<summary>
Rewrites an expression tree to make it suitable for translation to SQL appropriate for SQL Server 2000
In particular, it replaces expressions that are not directly supported on SQL Server 2000
with alternative translations. The following expressions are translated:
<list type="bullet">
<item>
<see cref="T:System.Data.Entity.Core.Common.CommandTrees.DbExceptExpression"/>
</item>
<item>
<see cref="T:System.Data.Entity.Core.Common.CommandTrees.DbIntersectExpression"/>
</item>
<item>
<see cref="T:System.Data.Entity.Core.Common.CommandTrees.DbSkipExpression"/>
</item>
</list>
The other expressions are copied unmodified.
The new expression belongs to a new query command tree.
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.Sql8ExpressionRewriter.Rewrite(System.Data.Entity.Core.Common.CommandTrees.DbQueryCommandTree)">
<summary>
The only entry point.
Rewrites the given tree by replacing expressions that are not directly supported on SQL Server 2000
with alterntive translations.
</summary>
<param name="originalTree"> The tree to rewrite </param>
<returns> The new tree </returns>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.Sql8ExpressionRewriter.#ctor(System.Data.Entity.Core.Metadata.Edm.MetadataWorkspace)">
<summary>
Private Constructor.
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.Sql8ExpressionRewriter.Visit(System.Data.Entity.Core.Common.CommandTrees.DbExceptExpression)">
<summary>
<see cref="M:System.Data.Entity.SqlServer.SqlGen.Sql8ExpressionRewriter.TransformIntersectOrExcept(System.Data.Entity.Core.Common.CommandTrees.DbExpression,System.Data.Entity.Core.Common.CommandTrees.DbExpression,System.Data.Entity.Core.Common.CommandTrees.DbExpressionKind,System.Collections.Generic.IList{System.Data.Entity.Core.Common.CommandTrees.DbPropertyExpression},System.String)"/>
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.Sql8ExpressionRewriter.Visit(System.Data.Entity.Core.Common.CommandTrees.DbIntersectExpression)">
<summary>
<see cref="M:System.Data.Entity.SqlServer.SqlGen.Sql8ExpressionRewriter.TransformIntersectOrExcept(System.Data.Entity.Core.Common.CommandTrees.DbExpression,System.Data.Entity.Core.Common.CommandTrees.DbExpression,System.Data.Entity.Core.Common.CommandTrees.DbExpressionKind,System.Collections.Generic.IList{System.Data.Entity.Core.Common.CommandTrees.DbPropertyExpression},System.String)"/>
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.Sql8ExpressionRewriter.Visit(System.Data.Entity.Core.Common.CommandTrees.DbSkipExpression)">
<summary>
<see cref="M:System.Data.Entity.SqlServer.SqlGen.Sql8ExpressionRewriter.TransformIntersectOrExcept(System.Data.Entity.Core.Common.CommandTrees.DbExpression,System.Data.Entity.Core.Common.CommandTrees.DbExpression,System.Data.Entity.Core.Common.CommandTrees.DbExpressionKind,System.Collections.Generic.IList{System.Data.Entity.Core.Common.CommandTrees.DbPropertyExpression},System.String)"/>
Logicaly, <see cref="T:System.Data.Entity.Core.Common.CommandTrees.DbSkipExpression"/> translates to:
SELECT Y.x1, Y.x2, ..., Y.xn
FROM (
SELECT X.x1, X.x2, ..., X.xn,
FROM input AS X
EXCEPT
SELECT TOP(count) Z.x1, Z.x2, ..., Z.xn
FROM input AS Z
ORDER BY sk1, sk2, ...
) AS Y
ORDER BY sk1, sk2, ...
Here, input refers to the input of the <see cref="T:System.Data.Entity.Core.Common.CommandTrees.DbSkipExpression"/>, and count to the count property of the
<see cref="T:System.Data.Entity.Core.Common.CommandTrees.DbSkipExpression"/>
.
The implementation of EXCEPT is non-duplicate eliminating, and does equality comparison only over the
equality comparable columns of the input.
This corresponds to the following expression tree:
SORT
|
NON-DISTINCT EXCEPT (specially translated,
|
| - Left: clone of input
| - Right:
|
Limit
|
| - Limit: Count
| - Input
|
Sort
|
input
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.Sql8ExpressionRewriter.TransformIntersectOrExcept(System.Data.Entity.Core.Common.CommandTrees.DbExpression,System.Data.Entity.Core.Common.CommandTrees.DbExpression,System.Data.Entity.Core.Common.CommandTrees.DbExpressionKind)">
<summary>
This method is invoked when tranforming <see cref="T:System.Data.Entity.Core.Common.CommandTrees.DbIntersectExpression"/> and <see cref="T:System.Data.Entity.Core.Common.CommandTrees.DbExceptExpression"/> by doing comparison over all input columns.
<see cref="M:System.Data.Entity.SqlServer.SqlGen.Sql8ExpressionRewriter.TransformIntersectOrExcept(System.Data.Entity.Core.Common.CommandTrees.DbExpression,System.Data.Entity.Core.Common.CommandTrees.DbExpression,System.Data.Entity.Core.Common.CommandTrees.DbExpressionKind,System.Collections.Generic.IList{System.Data.Entity.Core.Common.CommandTrees.DbPropertyExpression},System.String)"/>
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.Sql8ExpressionRewriter.TransformIntersectOrExcept(System.Data.Entity.Core.Common.CommandTrees.DbExpression,System.Data.Entity.Core.Common.CommandTrees.DbExpression,System.Data.Entity.Core.Common.CommandTrees.DbExpressionKind,System.Collections.Generic.IList{System.Data.Entity.Core.Common.CommandTrees.DbPropertyExpression},System.String)">
<summary>
This method is used for translating <see cref="T:System.Data.Entity.Core.Common.CommandTrees.DbIntersectExpression"/> and <see cref="T:System.Data.Entity.Core.Common.CommandTrees.DbExceptExpression"/>,
and for translating the "Except" part of <see cref="T:System.Data.Entity.Core.Common.CommandTrees.DbSkipExpression"/>.
into the follwoing expression:
A INTERSECT B, A EXCEPT B
(DISTINCT)
|
FILTER
|
| - Input: A
| - Predicate:(NOT)
|
ANY
|
| - Input: B
| - Predicate: (B.b1 = A.a1 or (B.b1 is null and A.a1 is null))
AND (B.b2 = A.a2 or (B.b2 is null and A.a2 is null))
AND ...
AND (B.bn = A.an or (B.bn is null and A.an is null)))
Here, A corresponds to right and B to left.
(NOT) is present when transforming Except
for the purpose of translating <see cref="T:System.Data.Entity.Core.Common.CommandTrees.DbExceptExpression"/> or <see cref="T:System.Data.Entity.Core.Common.CommandTrees.DbSkipExpression"/>.
(DISTINCT) is present when transforming for the purpose of translating
<see cref="T:System.Data.Entity.Core.Common.CommandTrees.DbExceptExpression"/> or <see cref="T:System.Data.Entity.Core.Common.CommandTrees.DbIntersectExpression"/>.
For <see cref="T:System.Data.Entity.Core.Common.CommandTrees.DbSkipExpression"/>, the input to ANY is caped with project which projects out only
the columns represented in the sortExpressionsOverLeft list and only these are used in the predicate.
This is because we want to support skip over input with non-equal comarable columns and we have no way to recognize these.
</summary>
<param name="left"> </param>
<param name="right"> </param>
<param name="expressionKind"> </param>
<param name="sortExpressionsOverLeft"> note that this list gets destroyed by this method </param>
<param name="sortExpressionsBindingVariableName"> </param>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.Sql8ExpressionRewriter.FlattenProperties(System.Data.Entity.Core.Common.CommandTrees.DbExpression,System.Collections.Generic.IList{System.Data.Entity.Core.Common.CommandTrees.DbPropertyExpression})">
<summary>
Adds the flattened properties on the input to the flattenedProperties list.
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.Sql8ExpressionRewriter.RemoveNonSortProperties(System.Collections.Generic.IList{System.Data.Entity.Core.Common.CommandTrees.DbPropertyExpression},System.Collections.Generic.IList{System.Data.Entity.Core.Common.CommandTrees.DbPropertyExpression},System.Collections.Generic.IList{System.Data.Entity.Core.Common.CommandTrees.DbPropertyExpression},System.String,System.String)">
<summary>
Helper method for
<see cref="M:System.Data.Entity.SqlServer.SqlGen.Sql8ExpressionRewriter.TransformIntersectOrExcept(System.Data.Entity.Core.Common.CommandTrees.DbExpression,System.Data.Entity.Core.Common.CommandTrees.DbExpression,System.Data.Entity.Core.Common.CommandTrees.DbExpressionKind,System.Collections.Generic.IList{System.Data.Entity.Core.Common.CommandTrees.DbPropertyExpression},System.String)"/>
Removes all pairs of property expressions from list1 and list2, for which the property expression in list1
does not have a 'matching' property expression in list2.
The lists list1 and list2 are known to not create duplicate, and the purpose of the sortList is just for this method.
Thus, to optimize the match process, we remove the seen property expressions from the sort list in
<see cref="M:System.Data.Entity.SqlServer.SqlGen.Sql8ExpressionRewriter.HasMatchInList(System.Data.Entity.Core.Common.CommandTrees.DbPropertyExpression,System.Collections.Generic.IList{System.Data.Entity.Core.Common.CommandTrees.DbPropertyExpression},System.String,System.String)"/>
when iterating both list simultaneously.
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.Sql8ExpressionRewriter.HasMatchInList(System.Data.Entity.Core.Common.CommandTrees.DbPropertyExpression,System.Collections.Generic.IList{System.Data.Entity.Core.Common.CommandTrees.DbPropertyExpression},System.String,System.String)">
<summary>
Helper method for <see cref="M:System.Data.Entity.SqlServer.SqlGen.Sql8ExpressionRewriter.RemoveNonSortProperties(System.Collections.Generic.IList{System.Data.Entity.Core.Common.CommandTrees.DbPropertyExpression},System.Collections.Generic.IList{System.Data.Entity.Core.Common.CommandTrees.DbPropertyExpression},System.Collections.Generic.IList{System.Data.Entity.Core.Common.CommandTrees.DbPropertyExpression},System.String,System.String)"/>
Checks whether expr has a 'match' in the given list of property expressions.
If it does, the matching expression is removed form the list, to speed up future matching.
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.Sql8ExpressionRewriter.AreMatching(System.Data.Entity.Core.Common.CommandTrees.DbPropertyExpression,System.Data.Entity.Core.Common.CommandTrees.DbPropertyExpression,System.String,System.String)">
<summary>
Determines whether two expressions match.
They match if they are of the shape
expr1 -> DbPropertyExpression(... (DbPropertyExpression(DbVariableReferenceExpression(expr1BindingVariableName), nameX), ..., name1)
expr1 -> DbPropertyExpression(... (DbPropertyExpression(DbVariableReferenceExpression(expr2BindingVariableName), nameX), ..., name1),
i.e. if they only differ in the name of the binding.
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.Sql8ExpressionRewriter.CapWithProject(System.Data.Entity.Core.Common.CommandTrees.DbExpressionBinding,System.Collections.Generic.IList{System.Data.Entity.Core.Common.CommandTrees.DbPropertyExpression})">
<summary>
Helper method for
<see cref="M:System.Data.Entity.SqlServer.SqlGen.Sql8ExpressionRewriter.TransformIntersectOrExcept(System.Data.Entity.Core.Common.CommandTrees.DbExpression,System.Data.Entity.Core.Common.CommandTrees.DbExpression,System.Data.Entity.Core.Common.CommandTrees.DbExpressionKind,System.Collections.Generic.IList{System.Data.Entity.Core.Common.CommandTrees.DbPropertyExpression},System.String)"/>
Creates a
<see cref="T:System.Data.Entity.Core.Common.CommandTrees.DbProjectExpression"/>
over the given inputBinding that projects out the given flattenedProperties.
and updates the flattenedProperties to be over the newly created project.
</summary>
<returns>
An <see cref="T:System.Data.Entity.Core.Common.CommandTrees.DbExpressionBinding"/> over the newly created <see cref="T:System.Data.Entity.Core.Common.CommandTrees.DbProjectExpression"/>
</returns>
</member>
<member name="T:System.Data.Entity.SqlServer.SqlGen.SqlBuilder">
<summary>
This class is like StringBuilder. While traversing the tree for the first time,
we do not know all the strings that need to be appended e.g. things that need to be
renamed, nested select statements etc. So, we use a builder that can collect
all kinds of sql fragments.
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlBuilder.Append(System.Object)">
<summary>
Add an object to the list - we do not verify that it is a proper sql fragment
since this is an internal method.
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlBuilder.AppendLine">
<summary>
This is to pretty print the SQL. The writer <see cref="T:System.Data.Entity.SqlServer.SqlGen.SqlWriter"/>
needs to know about new lines so that it can add the right amount of
indentation at the beginning of lines.
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlBuilder.WriteSql(System.Data.Entity.SqlServer.SqlGen.SqlWriter,System.Data.Entity.SqlServer.SqlGen.SqlGenerator)">
<summary>
We delegate the writing of the fragment to the appropriate type.
</summary>
</member>
<member name="P:System.Data.Entity.SqlServer.SqlGen.SqlBuilder.IsEmpty">
<summary>
Whether the builder is empty. This is used by the <see cref="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.Visit(System.Data.Entity.Core.Common.CommandTrees.DbProjectExpression)"/>
to determine whether a sql statement can be reused.
</summary>
</member>
<member name="T:System.Data.Entity.SqlServer.SqlGen.SqlFunctionCallHandler">
<summary>
Enacapsulates the logic required to translate function calls represented as instances of DbFunctionExpression into SQL.
There are several special cases that modify how the translation should proceed. These include:
- 'Special' canonical functions, for which the function name or arguments differ between the EDM canonical function and the SQL function
- 'Special' server functions, which are similar to the 'special' canonical functions but sourced by the SQL Server provider manifest
- Niladic functions, which require the parentheses that would usually follow the function name to be omitted
- Spatial canonical functions, which must translate to a static method call, instance method call, or instance property access against
one of the built-in spatial CLR UDTs (geography/geometry).
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlFunctionCallHandler.InitializeStoreFunctionHandlers">
<summary>
All special store functions and their handlers
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlFunctionCallHandler.InitializeCanonicalFunctionHandlers">
<summary>
All special non-aggregate canonical functions and their handlers
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlFunctionCallHandler.InitializeFunctionNameToOperatorDictionary">
<summary>
Initalizes the mapping from functions to TSql operators
for all functions that translate to TSql operators
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlFunctionCallHandler.InitializeDateAddFunctionNameToDatepartDictionary">
<summary>
Initalizes the mapping from names of canonical function for date/time addition
to corresponding dateparts
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlFunctionCallHandler.InitializeDateDiffFunctionNameToDatepartDictionary">
<summary>
Initalizes the mapping from names of canonical function for date/time difference
to corresponding dateparts
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlFunctionCallHandler.InitializeGeographyStaticMethodFunctionsDictionary">
<summary>
Initalizes the mapping from names of canonical function that represent static geography methods to their corresponding
static method name, qualified with the 'geography::' prefix.
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlFunctionCallHandler.InitializeGeographyInstancePropertyFunctionsDictionary">
<summary>
Initalizes the mapping from names of canonical function that represent geography instance properties to their corresponding
store property name.
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlFunctionCallHandler.InitializeRenamedGeographyInstanceMethodFunctions">
<summary>
Initalizes the mapping of canonical function name to instance method name for geography instance functions that differ in name from the sql server equivalent.
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlFunctionCallHandler.InitializeGeometryStaticMethodFunctionsDictionary">
<summary>
Initalizes the mapping from names of canonical function that represent static geometry methods to their corresponding
static method name, qualified with the 'geometry::' prefix.
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlFunctionCallHandler.InitializeGeometryInstancePropertyFunctionsDictionary">
<summary>
Initalizes the mapping from names of canonical function that represent geometry instance properties to their corresponding
store property name.
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlFunctionCallHandler.InitializeRenamedGeometryInstanceMethodFunctions">
<summary>
Initalizes the mapping of canonical function name to instance method name for geometry instance functions that differ in name from the sql server equivalent.
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlFunctionCallHandler.IsSpecialStoreFunction(System.Data.Entity.Core.Common.CommandTrees.DbFunctionExpression)">
<summary>
Determines whether the given function is a store function that
requires special handling
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlFunctionCallHandler.IsSpecialCanonicalFunction(System.Data.Entity.Core.Common.CommandTrees.DbFunctionExpression)">
<summary>
Determines whether the given function is a canonical function that
requires special handling
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlFunctionCallHandler.IsSpatialCanonicalFunction(System.Data.Entity.Core.Common.CommandTrees.DbFunctionExpression,System.Data.Entity.Core.Metadata.Edm.PrimitiveTypeKind@)">
<summary>
Determines whether the given function is a canonical function the translates
to a spatial (geography/geometry) property access or method call.
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlFunctionCallHandler.HandleFunctionDefault(System.Data.Entity.SqlServer.SqlGen.SqlGenerator,System.Data.Entity.Core.Common.CommandTrees.DbFunctionExpression)">
<summary>
Default handling for functions.
Translates them to FunctionName(arg1, arg2, ..., argn)
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlFunctionCallHandler.HandleFunctionDefaultGivenName(System.Data.Entity.SqlServer.SqlGen.SqlGenerator,System.Data.Entity.Core.Common.CommandTrees.DbFunctionExpression,System.String)">
<summary>
Default handling for functions with a given name.
Translates them to FunctionName(arg1, arg2, ..., argn)
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlFunctionCallHandler.HandleFunctionDefaultCastReturnValue(System.Data.Entity.SqlServer.SqlGen.SqlGenerator,System.Data.Entity.Core.Common.CommandTrees.DbFunctionExpression,System.String,System.String)">
<summary>
Default handling for functions with a given name and given return value cast.
Translates them to CAST(FunctionName(arg1, arg2, ..., argn) AS returnType)
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlFunctionCallHandler.HandleFunctionArgumentsDefault(System.Data.Entity.SqlServer.SqlGen.SqlGenerator,System.Data.Entity.Core.Common.CommandTrees.DbFunctionExpression,System.Data.Entity.SqlServer.SqlGen.SqlBuilder)">
<summary>
Default handling on function arguments.
Appends the list of arguments to the given result
If the function is niladic it does not append anything,
otherwise it appends (arg1, arg2, .., argn)
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlFunctionCallHandler.HandleFunctionGivenNameBasedOnVersion(System.Data.Entity.SqlServer.SqlGen.SqlGenerator,System.Data.Entity.Core.Common.CommandTrees.DbFunctionExpression,System.String,System.String)">
<summary>
Handler for functions that need to be translated to different store function based on version
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlFunctionCallHandler.HandleSpecialStoreFunction(System.Data.Entity.SqlServer.SqlGen.SqlGenerator,System.Data.Entity.Core.Common.CommandTrees.DbFunctionExpression)">
<summary>
Handler for special build in functions
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlFunctionCallHandler.HandleSpecialCanonicalFunction(System.Data.Entity.SqlServer.SqlGen.SqlGenerator,System.Data.Entity.Core.Common.CommandTrees.DbFunctionExpression)">
<summary>
Handler for special canonical functions
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlFunctionCallHandler.HandleSpecialFunction(System.Collections.Generic.Dictionary{System.String,System.Data.Entity.SqlServer.SqlGen.SqlFunctionCallHandler.FunctionHandler},System.Data.Entity.SqlServer.SqlGen.SqlGenerator,System.Data.Entity.Core.Common.CommandTrees.DbFunctionExpression)">
<summary>
Dispatches the special function processing to the appropriate handler
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlFunctionCallHandler.HandleSpecialFunctionToOperator(System.Data.Entity.SqlServer.SqlGen.SqlGenerator,System.Data.Entity.Core.Common.CommandTrees.DbFunctionExpression,System.Boolean)">
<summary>
Handles functions that are translated into TSQL operators.
The given function should have one or two arguments.
Functions with one arguemnt are translated into
op arg
Functions with two arguments are translated into
arg0 op arg1
Also, the arguments can be optionaly enclosed in parethesis
</summary>
<param name="sqlgen"> </param>
<param name="e"> </param>
<param name="parenthesiseArguments"> Whether the arguments should be enclosed in parethesis </param>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlFunctionCallHandler.HandleConcatFunction(System.Data.Entity.SqlServer.SqlGen.SqlGenerator,System.Data.Entity.Core.Common.CommandTrees.DbFunctionExpression)">
<summary>
<see cref="M:System.Data.Entity.SqlServer.SqlGen.SqlFunctionCallHandler.HandleSpecialFunctionToOperator(System.Data.Entity.SqlServer.SqlGen.SqlGenerator,System.Data.Entity.Core.Common.CommandTrees.DbFunctionExpression,System.Boolean)"></see>
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlFunctionCallHandler.HandleCanonicalFunctionBitwise(System.Data.Entity.SqlServer.SqlGen.SqlGenerator,System.Data.Entity.Core.Common.CommandTrees.DbFunctionExpression)">
<summary>
<see cref="M:System.Data.Entity.SqlServer.SqlGen.SqlFunctionCallHandler.HandleSpecialFunctionToOperator(System.Data.Entity.SqlServer.SqlGen.SqlGenerator,System.Data.Entity.Core.Common.CommandTrees.DbFunctionExpression,System.Boolean)"></see>
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlFunctionCallHandler.HandleDatepartDateFunction(System.Data.Entity.SqlServer.SqlGen.SqlGenerator,System.Data.Entity.Core.Common.CommandTrees.DbFunctionExpression)">
<summary>
Handles special case in which datapart 'type' parameter is present. all the functions
handles here have *only* the 1st parameter as datepart. datepart value is passed along
the QP as string and has to be expanded as TSQL keyword.
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlFunctionCallHandler.HandleCanonicalFunctionDatepart(System.Data.Entity.SqlServer.SqlGen.SqlGenerator,System.Data.Entity.Core.Common.CommandTrees.DbFunctionExpression)">
<summary>
Handler for canonical functions for extracting date parts.
For example:
Year(date) -> DATEPART( year, date)
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlFunctionCallHandler.HandleCanonicalFunctionGetTotalOffsetMinutes(System.Data.Entity.SqlServer.SqlGen.SqlGenerator,System.Data.Entity.Core.Common.CommandTrees.DbFunctionExpression)">
<summary>
Handler for canonical funcitons for GetTotalOffsetMinutes.
GetTotalOffsetMinutes(e) --> Datepart(tzoffset, e)
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlFunctionCallHandler.HandleCanonicalFunctionDatepart(System.Data.Entity.SqlServer.SqlGen.SqlGenerator,System.String,System.Data.Entity.Core.Common.CommandTrees.DbFunctionExpression)">
<summary>
Handler for turning a canonical function into DATEPART
Results in DATEPART(datepart, e)
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlFunctionCallHandler.HandleCanonicalFunctionCurrentDateTime(System.Data.Entity.SqlServer.SqlGen.SqlGenerator,System.Data.Entity.Core.Common.CommandTrees.DbFunctionExpression)">
<summary>
Handler for the canonical function CurrentDateTime
For Sql8 and Sql9: CurrentDateTime() -> GetDate()
For Sql10: CurrentDateTime() -> SysDateTime()
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlFunctionCallHandler.HandleCanonicalFunctionCurrentUtcDateTime(System.Data.Entity.SqlServer.SqlGen.SqlGenerator,System.Data.Entity.Core.Common.CommandTrees.DbFunctionExpression)">
<summary>
Handler for the canonical function CurrentUtcDateTime
For Sql8 and Sql9: CurrentUtcDateTime() -> GetUtcDate()
For Sql10: CurrentUtcDateTime() -> SysUtcDateTime()
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlFunctionCallHandler.HandleCanonicalFunctionCurrentDateTimeOffset(System.Data.Entity.SqlServer.SqlGen.SqlGenerator,System.Data.Entity.Core.Common.CommandTrees.DbFunctionExpression)">
<summary>
Handler for the canonical function CurrentDateTimeOffset
For Sql8 and Sql9: throw
For Sql10: CurrentDateTimeOffset() -> SysDateTimeOffset()
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlFunctionCallHandler.HandleCanonicalFunctionCreateDateTime(System.Data.Entity.SqlServer.SqlGen.SqlGenerator,System.Data.Entity.Core.Common.CommandTrees.DbFunctionExpression)">
<summary>
See <see cref="M:System.Data.Entity.SqlServer.SqlGen.SqlFunctionCallHandler.HandleCanonicalFunctionDateTimeTypeCreation(System.Data.Entity.SqlServer.SqlGen.SqlGenerator,System.String,System.Collections.Generic.IList{System.Data.Entity.Core.Common.CommandTrees.DbExpression},System.Boolean,System.Boolean)"/> for exact translation
Pre Katmai creates datetime.
On Katmai creates datetime2.
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlFunctionCallHandler.HandleCanonicalFunctionCreateDateTimeOffset(System.Data.Entity.SqlServer.SqlGen.SqlGenerator,System.Data.Entity.Core.Common.CommandTrees.DbFunctionExpression)">
<summary>
See <see cref="M:System.Data.Entity.SqlServer.SqlGen.SqlFunctionCallHandler.HandleCanonicalFunctionDateTimeTypeCreation(System.Data.Entity.SqlServer.SqlGen.SqlGenerator,System.String,System.Collections.Generic.IList{System.Data.Entity.Core.Common.CommandTrees.DbExpression},System.Boolean,System.Boolean)"/> for exact translation
Pre Katmai not supported.
On Katmai creates datetimeoffset.
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlFunctionCallHandler.HandleCanonicalFunctionCreateTime(System.Data.Entity.SqlServer.SqlGen.SqlGenerator,System.Data.Entity.Core.Common.CommandTrees.DbFunctionExpression)">
<summary>
See <see cref="M:System.Data.Entity.SqlServer.SqlGen.SqlFunctionCallHandler.HandleCanonicalFunctionDateTimeTypeCreation(System.Data.Entity.SqlServer.SqlGen.SqlGenerator,System.String,System.Collections.Generic.IList{System.Data.Entity.Core.Common.CommandTrees.DbExpression},System.Boolean,System.Boolean)"/> for exact translation
Pre Katmai not supported.
On Katmai creates time.
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlFunctionCallHandler.HandleCanonicalFunctionDateTimeTypeCreation(System.Data.Entity.SqlServer.SqlGen.SqlGenerator,System.String,System.Collections.Generic.IList{System.Data.Entity.Core.Common.CommandTrees.DbExpression},System.Boolean,System.Boolean)">
<summary>
Helper for all date and time types creating functions.
The given expression is in general trainslated into:
CONVERT(@typename, [datePart] + [timePart] + [timeZonePart], 121), where the datePart and the timeZonePart are optional
The individual parts are translated as:
Date part:
convert(varchar(255), @year) + '-' + convert(varchar(255), @month) + '-' + convert(varchar(255), @day)
Time part:
PRE KATMAI: convert(varchar(255), @hour)+ ':' + convert(varchar(255), @minute)+ ':' + str(@second, 6, 3)
KATMAI: convert(varchar(255), @hour)+ ':' + convert(varchar(255), @minute)+ ':' + str(@second, 10, 7)
Time zone part:
(case when @tzoffset >= 0 then '+' else '-' end) + convert(varchar(255), ABS(@tzoffset)/60) + ':' + convert(varchar(255), ABS(@tzoffset)%60)
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlFunctionCallHandler.AppendConvertToVarchar(System.Data.Entity.SqlServer.SqlGen.SqlGenerator,System.Data.Entity.SqlServer.SqlGen.SqlBuilder,System.Data.Entity.Core.Common.CommandTrees.DbExpression)">
<summary>
Helper method that wrapps the given expession with a conver to varchar(255)
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlFunctionCallHandler.HandleCanonicalFunctionTruncateTime(System.Data.Entity.SqlServer.SqlGen.SqlGenerator,System.Data.Entity.Core.Common.CommandTrees.DbFunctionExpression)">
<summary>
TruncateTime(DateTime X)
PreKatmai: TRUNCATETIME(X) => CONVERT(DATETIME, CONVERT(VARCHAR(255), expression, 102), 102)
Katmai: TRUNCATETIME(X) => CONVERT(DATETIME2, CONVERT(VARCHAR(255), expression, 102), 102)
TruncateTime(DateTimeOffset X)
TRUNCATETIME(X) => CONVERT(datetimeoffset, CONVERT(VARCHAR(255), expression, 102)
+ ' 00:00:00 ' + Right(convert(varchar(255), @arg, 121), 6), 102)
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlFunctionCallHandler.HandleCanonicalFunctionDateAddKatmaiOrNewer(System.Data.Entity.SqlServer.SqlGen.SqlGenerator,System.Data.Entity.Core.Common.CommandTrees.DbFunctionExpression)">
<summary>
Handler for date addition functions supported only starting from Katmai
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlFunctionCallHandler.HandleCanonicalFunctionDateAdd(System.Data.Entity.SqlServer.SqlGen.SqlGenerator,System.Data.Entity.Core.Common.CommandTrees.DbFunctionExpression)">
<summary>
Handler for all date/time addition canonical functions.
Translation, e.g.
AddYears(datetime, number) => DATEADD(year, number, datetime)
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlFunctionCallHandler.HandleCanonicalFunctionDateDiffKatmaiOrNewer(System.Data.Entity.SqlServer.SqlGen.SqlGenerator,System.Data.Entity.Core.Common.CommandTrees.DbFunctionExpression)">
<summary>
Hanndler for date differencing functions supported only starting from Katmai
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlFunctionCallHandler.HandleCanonicalFunctionDateDiff(System.Data.Entity.SqlServer.SqlGen.SqlGenerator,System.Data.Entity.Core.Common.CommandTrees.DbFunctionExpression)">
<summary>
Handler for all date/time addition canonical functions.
Translation, e.g.
DiffYears(datetime, number) => DATEDIFF(year, number, datetime)
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlFunctionCallHandler.HandleCanonicalFunctionIndexOf(System.Data.Entity.SqlServer.SqlGen.SqlGenerator,System.Data.Entity.Core.Common.CommandTrees.DbFunctionExpression)">
<summary>
Function rename IndexOf -> CHARINDEX
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlFunctionCallHandler.HandleCanonicalFunctionNewGuid(System.Data.Entity.SqlServer.SqlGen.SqlGenerator,System.Data.Entity.Core.Common.CommandTrees.DbFunctionExpression)">
<summary>
Function rename NewGuid -> NEWID
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlFunctionCallHandler.HandleCanonicalFunctionLength(System.Data.Entity.SqlServer.SqlGen.SqlGenerator,System.Data.Entity.Core.Common.CommandTrees.DbFunctionExpression)">
<summary>
Function rename Length -> LEN
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlFunctionCallHandler.HandleCanonicalFunctionRound(System.Data.Entity.SqlServer.SqlGen.SqlGenerator,System.Data.Entity.Core.Common.CommandTrees.DbFunctionExpression)">
<summary>
Round(numericExpression) -> Round(numericExpression, 0);
Round(numericExpression, digits) -> Round(numericExpression, digits);
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlFunctionCallHandler.HandleCanonicalFunctionTruncate(System.Data.Entity.SqlServer.SqlGen.SqlGenerator,System.Data.Entity.Core.Common.CommandTrees.DbFunctionExpression)">
<summary>
Truncate(numericExpression) -> Round(numericExpression, 0, 1); (does not exist as canonical function yet)
Truncate(numericExpression, digits) -> Round(numericExpression, digits, 1);
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlFunctionCallHandler.HandleCanonicalFunctionRoundOrTruncate(System.Data.Entity.SqlServer.SqlGen.SqlGenerator,System.Data.Entity.Core.Common.CommandTrees.DbFunctionExpression,System.Boolean)">
<summary>
Common handler for the canonical functions ROUND and TRUNCATE
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlFunctionCallHandler.HandleCanonicalFunctionAbs(System.Data.Entity.SqlServer.SqlGen.SqlGenerator,System.Data.Entity.Core.Common.CommandTrees.DbFunctionExpression)">
<summary>
Handle the canonical function Abs().
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlFunctionCallHandler.HandleCanonicalFunctionTrim(System.Data.Entity.SqlServer.SqlGen.SqlGenerator,System.Data.Entity.Core.Common.CommandTrees.DbFunctionExpression)">
<summary>
TRIM(string) -> LTRIM(RTRIM(string))
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlFunctionCallHandler.HandleCanonicalFunctionToLower(System.Data.Entity.SqlServer.SqlGen.SqlGenerator,System.Data.Entity.Core.Common.CommandTrees.DbFunctionExpression)">
<summary>
Function rename ToLower -> LOWER
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlFunctionCallHandler.HandleCanonicalFunctionToUpper(System.Data.Entity.SqlServer.SqlGen.SqlGenerator,System.Data.Entity.Core.Common.CommandTrees.DbFunctionExpression)">
<summary>
Function rename ToUpper -> UPPER
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlFunctionCallHandler.TranslateConstantParameterForLike(System.Data.Entity.SqlServer.SqlGen.SqlGenerator,System.Data.Entity.Core.Common.CommandTrees.DbExpression,System.Data.Entity.Core.Common.CommandTrees.DbConstantExpression,System.Data.Entity.SqlServer.SqlGen.SqlBuilder,System.Boolean,System.Boolean)">
<summary>
Function to translate the StartsWith, EndsWith and Contains canonical functions to LIKE expression in T-SQL
and also add the trailing ESCAPE '~' when escaping of the search string for the LIKE expression has occurred
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlFunctionCallHandler.HandleCanonicalFunctionContains(System.Data.Entity.SqlServer.SqlGen.SqlGenerator,System.Data.Entity.Core.Common.CommandTrees.DbFunctionExpression)">
<summary>
Handler for Contains. Wraps the normal translation with a case statement
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlFunctionCallHandler.HandleCanonicalFunctionContains(System.Data.Entity.SqlServer.SqlGen.SqlGenerator,System.Collections.Generic.IList{System.Data.Entity.Core.Common.CommandTrees.DbExpression},System.Data.Entity.SqlServer.SqlGen.SqlBuilder)">
<summary>
CONTAINS(arg0, arg1) => arg0 LIKE '%arg1%'
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlFunctionCallHandler.HandleCanonicalFunctionStartsWith(System.Data.Entity.SqlServer.SqlGen.SqlGenerator,System.Data.Entity.Core.Common.CommandTrees.DbFunctionExpression)">
<summary>
Handler for StartsWith. Wraps the normal translation with a case statement
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlFunctionCallHandler.HandleCanonicalFunctionStartsWith(System.Data.Entity.SqlServer.SqlGen.SqlGenerator,System.Collections.Generic.IList{System.Data.Entity.Core.Common.CommandTrees.DbExpression},System.Data.Entity.SqlServer.SqlGen.SqlBuilder)">
<summary>
STARTSWITH(arg0, arg1) => arg0 LIKE 'arg1%'
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlFunctionCallHandler.HandleCanonicalFunctionEndsWith(System.Data.Entity.SqlServer.SqlGen.SqlGenerator,System.Data.Entity.Core.Common.CommandTrees.DbFunctionExpression)">
<summary>
Handler for EndsWith. Wraps the normal translation with a case statement
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlFunctionCallHandler.HandleCanonicalFunctionEndsWith(System.Data.Entity.SqlServer.SqlGen.SqlGenerator,System.Collections.Generic.IList{System.Data.Entity.Core.Common.CommandTrees.DbExpression},System.Data.Entity.SqlServer.SqlGen.SqlBuilder)">
<summary>
ENDSWITH(arg0, arg1) => arg0 LIKE '%arg1'
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlFunctionCallHandler.WrapPredicate(System.Func{System.Data.Entity.SqlServer.SqlGen.SqlGenerator,System.Collections.Generic.IList{System.Data.Entity.Core.Common.CommandTrees.DbExpression},System.Data.Entity.SqlServer.SqlGen.SqlBuilder,System.Data.Entity.SqlServer.SqlGen.SqlBuilder},System.Data.Entity.SqlServer.SqlGen.SqlGenerator,System.Data.Entity.Core.Common.CommandTrees.DbFunctionExpression)">
<summary>
Turns a predicate into a statement returning a bit
PREDICATE => CASE WHEN (PREDICATE) THEN CAST(1 AS BIT) WHEN (NOT (PREDICATE)) CAST (O AS BIT) END
The predicate is produced by the given predicateTranslator.
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlFunctionCallHandler.WriteFunctionName(System.Data.Entity.SqlServer.SqlGen.SqlBuilder,System.Data.Entity.Core.Metadata.Edm.EdmFunction)">
<summary>
Writes the function name to the given SqlBuilder.
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlFunctionCallHandler.IsStoreFunction(System.Data.Entity.Core.Metadata.Edm.EdmFunction)">
<summary>
Is this a Store function (ie) does it have the builtinAttribute specified and it is not a canonical function?
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlFunctionCallHandler.CastReturnTypeToInt64(System.Data.Entity.Core.Common.CommandTrees.DbFunctionExpression)">
<summary>
determines if the function requires the return type be enforeced by use of a cast expression
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlFunctionCallHandler.CastReturnTypeToInt32(System.Data.Entity.SqlServer.SqlGen.SqlGenerator,System.Data.Entity.Core.Common.CommandTrees.DbFunctionExpression)">
<summary>
determines if the function requires the return type be enforeced by use of a cast expression
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlFunctionCallHandler.CastReturnTypeToInt16(System.Data.Entity.Core.Common.CommandTrees.DbFunctionExpression)">
<summary>
determines if the function requires the return type be enforeced by use of a cast expression
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlFunctionCallHandler.CastReturnTypeToSingle(System.Data.Entity.Core.Common.CommandTrees.DbFunctionExpression)">
<summary>
determines if the function requires the return type be enforeced by use of a cast expression
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlFunctionCallHandler.CastReturnTypeToGivenType(System.Data.Entity.Core.Common.CommandTrees.DbFunctionExpression,System.Collections.Generic.ISet{System.String},System.Data.Entity.Core.Metadata.Edm.PrimitiveTypeKind)">
<summary>
Determines if the function requires the return type be enforced by use of a cast expression
</summary>
</member>
<member name="T:System.Data.Entity.SqlServer.SqlGen.SqlGenerator">
<summary>
Translates the command object into a SQL string that can be executed on
SQL Server 2000 and SQL Server 2005.
</summary>
<remarks>
The translation is implemented as a visitor <see cref="T:System.Data.Entity.Core.Common.CommandTrees.DbExpressionVisitor`1"/>
over the query tree. It makes a single pass over the tree, collecting the sql
fragments for the various nodes in the tree <see cref="T:System.Data.Entity.SqlServer.SqlGen.ISqlFragment"/>.
The major operations are
<list type="bullet">
<item>
Select statement minimization. Multiple nodes in the query tree
that can be part of a single SQL select statement are merged. e.g. a
Filter node that is the input of a Project node can typically share the
same SQL statement.
</item>
<item>
Alpha-renaming. As a result of the statement minimization above, there
could be name collisions when using correlated subqueries
<example>
<code>Filter(
b = Project( c.x
c = Extent(foo)
)
exists (
Filter(
c = Extent(foo)
b.x = c.x
)
)
)</code>
The first Filter, Project and Extent will share the same SQL select statement.
The alias for the Project i.e. b, will be replaced with c.
If the alias c for the Filter within the exists clause is not renamed,
we will get <c>c.x = c.x</c>, which is incorrect.
Instead, the alias c within the second filter should be renamed to c1, to give
<c>c.x = c1.x</c> i.e. b is renamed to c, and c is renamed to c1.
</example>
</item>
<item>
Join flattening. In the query tree, a list of join nodes is typically
represented as a tree of Join nodes, each with 2 children. e.g.
<example>
<code>a = Join(InnerJoin
b = Join(CrossJoin
c = Extent(foo)
d = Extent(foo)
)
e = Extent(foo)
on b.c.x = e.x
)</code>
If translated directly, this will be translated to
<code>FROM ( SELECT c.*, d.*
FROM foo as c
CROSS JOIN foo as d) as b
INNER JOIN foo as e on b.x' = e.x</code>
It would be better to translate this as
<code>FROM foo as c
CROSS JOIN foo as d
INNER JOIN foo as e on c.x = e.x</code>
This allows the optimizer to choose an appropriate join ordering for evaluation.
</example>
</item>
<item>
Select * and column renaming. In the example above, we noticed that
in some cases we add
<c>SELECT * FROM ...</c>
to complete the SQL
statement. i.e. there is no explicit PROJECT list.
In this case, we enumerate all the columns available in the FROM clause
This is particularly problematic in the case of Join trees, since the columns
from the extents joined might have the same name - this is illegal. To solve
this problem, we will have to rename columns if they are part of a SELECT *
for a JOIN node - we do not need renaming in any other situation.
<see cref="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.AddDefaultColumns(System.Data.Entity.SqlServer.SqlGen.SqlSelectStatement)"/>
.
</item>
</list>
<para> Renaming issues. When rows or columns are renamed, we produce names that are unique globally with respect to the query. The names are derived from the original names, with an integer as a suffix. e.g. CustomerId will be renamed to CustomerId1, CustomerId2 etc. Since the names generated are globally unique, they will not conflict when the columns of a JOIN SELECT statement are joined with another JOIN. </para>
<para>
Record flattening. SQL server does not have the concept of records. However, a join statement produces records. We have to flatten the record accesses into a simple <c>alias.column</c> form.
<see cref="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.Visit(System.Data.Entity.Core.Common.CommandTrees.DbPropertyExpression)"/>
</para>
<para>
Building the SQL. There are 2 phases
<list type="numbered">
<item>
Traverse the tree, producing a sql builder
<see cref="T:System.Data.Entity.SqlServer.SqlGen.SqlBuilder"/>
</item>
<item>
Write the SqlBuilder into a string, renaming the aliases and columns
as needed.
</item>
</list>
In the first phase, we traverse the tree. We cannot generate the SQL string right away, since
<list type="bullet">
<item>The WHERE clause has to be visited before the from clause.</item>
<item>
extent aliases and column aliases need to be renamed. To minimize
renaming collisions, all the names used must be known, before any renaming
choice is made.
</item>
</list>
To defer the renaming choices, we use symbols
<see cref="T:System.Data.Entity.SqlServer.SqlGen.Symbol"/>
. These are renamed in the second phase. Since visitor methods cannot transfer information to child nodes through parameters, we use some global stacks,
<list type="bullet">
<item>
A stack for the current SQL select statement. This is needed by
<see cref="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.Visit(System.Data.Entity.Core.Common.CommandTrees.DbVariableReferenceExpression)"/>
to create a
list of free variables used by a select statement. This is needed for
alias renaming.
</item>
<item>
A stack for the join context. When visiting an extent,
we need to know whether we are inside a join or not. If we are inside
a join, we do not create a new SELECT statement.
</item>
</list>
</para>
<para>
Global state. To enable renaming, we maintain
<list type="bullet">
<item>The set of all extent aliases used.</item>
<item>The set of all parameter names.</item>
<item>The set of all column names that may need to be renamed.</item>
</list>
Finally, we have a symbol table to lookup variable references. All references to the same extent have the same symbol.
</para>
<para>
Sql select statement sharing. Each of the relational operator nodes
<list type="bullet">
<item>Project</item>
<item>Filter</item>
<item>GroupBy</item>
<item>Sort/OrderBy</item>
</list>
can add its non-input (e.g. project, predicate, sort order etc.) to the SQL statement for the input, or create a new SQL statement. If it chooses to reuse the input's SQL statement, we play the following symbol table trick to accomplish renaming. The symbol table entry for the alias of the current node points to the symbol for the input in the input's SQL statement.
<example>
<code>Project(b.x
b = Filter(
c = Extent(foo)
c.x = 5)
)</code>
The Extent node creates a new SqlSelectStatement. This is added to the
symbol table by the Filter as {c, Symbol(c)}. Thus, <c>c.x</c> is resolved to
<c>Symbol(c).x</c>.
Looking at the project node, we add {b, Symbol(c)} to the symbol table if the
SQL statement is reused, and {b, Symbol(b)}, if there is no reuse.
Thus, <c>b.x</c> is resolved to <c>Symbol(c).x</c> if there is reuse, and to
<c>Symbol(b).x</c> if there is no reuse.
</example>
</para>
</remarks>
</member>
<member name="F:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.selectStatementStack">
<summary>
Every relational node has to pass its SELECT statement to its children
This allows them (DbVariableReferenceExpression eventually) to update the list of
outer extents (free variables) used by this select statement.
</summary>
</member>
<member name="F:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.isParentAJoinStack">
<summary>
Nested joins and extents need to know whether they should create
a new Select statement, or reuse the parent's. This flag
indicates whether the parent is a join or not.
</summary>
</member>
<member name="F:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.isVarRefSingle">
<summary>
VariableReferenceExpressions are allowed only as children of DbPropertyExpression
or MethodExpression. The cheapest way to ensure this is to set the following
property in DbVariableReferenceExpression and reset it in the allowed parent expressions.
</summary>
</member>
<member name="F:System.Data.Entity.SqlServer.SqlGen.SqlGenerator._candidateParametersToForceNonUnicode">
<summary>
Maintain the list of (string) DbParameterReferenceExpressions that should be compensated, viz.
forced to non-unicode format. A parameter is added to the list if it is being compared to a
non-unicode store column and none of its other usages in the query tree, disqualify it
(For example - if the parameter is also being projected or compared to a unicode column)
The goal of the compensation is to have the store index picked up by the server.
String constants are also compensated and the decision is local, unlike parameters.
</summary>
</member>
<member name="F:System.Data.Entity.SqlServer.SqlGen.SqlGenerator._forceNonUnicode">
<summary>
Set and reset in DbComparisonExpression and DbLikeExpression visit methods. Maintains
global state information that the children of these nodes are candidates for compensation.
</summary>
</member>
<member name="F:System.Data.Entity.SqlServer.SqlGen.SqlGenerator._ignoreForceNonUnicodeFlag">
<summary>
Set when it is is safe to ignore the unicode/non-unicode aspect. See <see cref="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.VisitIsNullExpression(System.Data.Entity.Core.Common.CommandTrees.DbIsNullExpression,System.Boolean)"/> for an example.
</summary>
</member>
<member name="F:System.Data.Entity.SqlServer.SqlGen.SqlGenerator._sqlVersion">
<summary>
The current SQL Server version
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.#ctor(System.Data.Entity.SqlServer.SqlVersion)">
<summary>
Basic constructor.
</summary>
<param name="sqlVersion"> server version </param>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.GenerateSql(System.Data.Entity.Core.Common.CommandTrees.DbCommandTree,System.Data.Entity.SqlServer.SqlVersion,System.Collections.Generic.List{System.Data.SqlClient.SqlParameter}@,System.Data.CommandType@,System.Collections.Generic.HashSet{System.String}@)">
<summary>
General purpose static function that can be called from System.Data assembly
</summary>
<param name="tree"> command tree </param>
<param name="sqlVersion"> Server version </param>
<param name="parameters"> Parameters to add to the command tree corresponding to constants in the command tree. Used only in ModificationCommandTrees. </param>
<param name="commandType"> CommandType for generated command. </param>
<param name="paramsToForceNonUnicode"> </param>
<returns> The string representing the SQL to be executed. </returns>\
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.GenerateSql(System.Data.Entity.Core.Common.CommandTrees.DbQueryCommandTree,System.Collections.Generic.HashSet{System.String}@)">
<summary>
Translate a command tree to a SQL string.
The input tree could be translated to either a SQL SELECT statement
or a SELECT expression. This choice is made based on the return type
of the expression
CollectionType => select statement
non collection type => select expression
</summary>
<returns> The string representing the SQL to be executed. </returns>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.WriteSql(System.Data.Entity.SqlServer.SqlGen.SqlWriter,System.Data.Entity.SqlServer.SqlGen.ISqlFragment)">
<summary>
Convert the SQL fragments to a string. Writes a string representing the SQL to be executed
into the specified writer.
</summary>
<param name="writer"> </param>
<param name="sqlStatement">The fragment to be emitted</param>
<returns>The writer specified for fluent continuations. </returns>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.Visit(System.Data.Entity.Core.Common.CommandTrees.DbAndExpression)">
<summary>
Translate(left) AND Translate(right)
</summary>
<returns>
A <see cref="T:System.Data.Entity.SqlServer.SqlGen.SqlBuilder"/> .
</returns>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.Visit(System.Data.Entity.Core.Common.CommandTrees.DbApplyExpression)">
<summary>
An apply is just like a join, so it shares the common join processing
in <see cref="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.VisitJoinExpression(System.Collections.Generic.IList{System.Data.Entity.Core.Common.CommandTrees.DbExpressionBinding},System.Data.Entity.Core.Common.CommandTrees.DbExpressionKind,System.String,System.Data.Entity.Core.Common.CommandTrees.DbExpression)"/>
</summary>
<returns>
A <see cref="T:System.Data.Entity.SqlServer.SqlGen.SqlSelectStatement"/> .
</returns>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.Visit(System.Data.Entity.Core.Common.CommandTrees.DbArithmeticExpression)">
<summary>
For binary expressions, we delegate to <see cref="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.VisitBinaryExpression(System.String,System.Data.Entity.Core.Common.CommandTrees.DbExpressionKind,System.Data.Entity.Core.Common.CommandTrees.DbExpression,System.Data.Entity.Core.Common.CommandTrees.DbExpression)"/>.
We handle the other expressions directly.
</summary>
<returns>
A <see cref="T:System.Data.Entity.SqlServer.SqlGen.SqlBuilder"/>
</returns>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.Visit(System.Data.Entity.Core.Common.CommandTrees.DbCaseExpression)">
<summary>
If the ELSE clause is null, we do not write it out.
</summary>
<returns>
A <see cref="T:System.Data.Entity.SqlServer.SqlGen.SqlBuilder"/>
</returns>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.Visit(System.Data.Entity.Core.Common.CommandTrees.DbComparisonExpression)">
<summary>
The parser generates Not(Equals(...)) for <>.
</summary>
<returns>
A <see cref="T:System.Data.Entity.SqlServer.SqlGen.SqlBuilder"/> .
</returns>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.CheckIfForceNonUnicodeRequired(System.Data.Entity.Core.Common.CommandTrees.DbExpression)">
<summary>
Checks if the arguments of the input Comparison or Like expression are candidates
for compensation. If yes, sets global state variable - _forceNonUnicode.
</summary>
<param name="e"> DBComparisonExpression or DbLikeExpression </param>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.MatchPatternForForcingNonUnicode(System.Data.Entity.Core.Common.CommandTrees.DbExpression)">
<summary>
The grammar for the pattern that we are looking for is -
Pattern := Target OP Source | Source OP Target
OP := Like | In | Comparison
Source := Non-unicode DbPropertyExpression
Target := Target FUNC Target | DbConstantExpression | DBParameterExpression
FUNC := CONCAT | RTRIM | LTRIM | TRIM | SUBSTRING | TOLOWER | TOUPPER | REVERSE | REPLACE
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.MatchTargetPatternForForcingNonUnicode(System.Data.Entity.Core.Common.CommandTrees.DbExpression)">
<summary>
Matches the non-terminal symbol "target" in above grammar.
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.MatchSourcePatternForForcingNonUnicode(System.Data.Entity.Core.Common.CommandTrees.DbExpression)">
<summary>
Determines if the expression represents a non-unicode string column(char/varchar store type)
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.IsConstParamOrNullExpressionUnicodeNotSpecified(System.Data.Entity.Core.Common.CommandTrees.DbExpression)">
<summary>
Determines if the expression represents a string constant or parameter with the facet, unicode=null.
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.VisitConstant(System.Data.Entity.Core.Common.CommandTrees.DbConstantExpression,System.Boolean)">
<summary>
Generate tsql for a constant. Avoid the explicit cast (if possible) when
the isCastOptional parameter is set
</summary>
<param name="e"> the constant expression </param>
<param name="isCastOptional"> can we avoid the CAST </param>
<returns> the tsql fragment </returns>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.AssertValidDouble(System.Double)">
<summary>
Helper method for <see cref="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.VisitConstant(System.Data.Entity.Core.Common.CommandTrees.DbConstantExpression,System.Boolean)"/>
</summary>
<param name="value"> A double value </param>
<exception cref="T:System.NotSupportedException">
If a value of positive or negative infinity, or
<see cref="F:System.Double.NaN"/>
is specified
</exception>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.AssertValidSingle(System.Single)">
<summary>
Helper method for <see cref="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.VisitConstant(System.Data.Entity.Core.Common.CommandTrees.DbConstantExpression,System.Boolean)"/>
</summary>
<param name="value"> A single value </param>
<exception cref="T:System.NotSupportedException">
If a value of positive or negative infinity, or
<see cref="F:System.Single.NaN"/>
is specified
</exception>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.WrapWithCastIfNeeded(System.Boolean,System.String,System.String,System.Data.Entity.SqlServer.SqlGen.SqlBuilder)">
<summary>
Helper function for <see cref="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.VisitConstant(System.Data.Entity.Core.Common.CommandTrees.DbConstantExpression,System.Boolean)"/>
Appends the given constant value to the result either 'as is' or wrapped with a cast to the given type.
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.Visit(System.Data.Entity.Core.Common.CommandTrees.DbConstantExpression)">
<summary>
We do not pass constants as parameters.
</summary>
<returns>
A <see cref="T:System.Data.Entity.SqlServer.SqlGen.SqlBuilder"/> . Strings are wrapped in single quotes and escaped. Numbers are written literally.
</returns>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.Visit(System.Data.Entity.Core.Common.CommandTrees.DbDistinctExpression)">
<summary>
The DISTINCT has to be added to the beginning of SqlSelectStatement.Select,
but it might be too late for that. So, we use a flag on SqlSelectStatement
instead, and add the "DISTINCT" in the second phase.
</summary>
<returns>
A <see cref="T:System.Data.Entity.SqlServer.SqlGen.SqlSelectStatement"/>
</returns>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.Visit(System.Data.Entity.Core.Common.CommandTrees.DbElementExpression)">
<summary>
An element expression returns a scalar - so it is translated to
( Select ... )
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.Visit(System.Data.Entity.Core.Common.CommandTrees.DbExceptExpression)">
<summary>
<see cref="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.Visit(System.Data.Entity.Core.Common.CommandTrees.DbUnionAllExpression)"/>
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.Visit(System.Data.Entity.Core.Common.CommandTrees.DbExpression)">
<summary>
Only concrete expression types will be visited.
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.Visit(System.Data.Entity.Core.Common.CommandTrees.DbScanExpression)">
<returns>
If we are in a Join context, returns a <see cref="T:System.Data.Entity.SqlServer.SqlGen.SqlBuilder"/> with the extent name, otherwise, a new
<see cref="T:System.Data.Entity.SqlServer.SqlGen.SqlSelectStatement"/>
with the From field set.
</returns>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.GetTargetTSql(System.Data.Entity.Core.Metadata.Edm.EntitySetBase)">
<summary>
Gets escaped TSql identifier describing this entity set.
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.Visit(System.Data.Entity.Core.Common.CommandTrees.DbFilterExpression)">
<summary>
The bodies of <see cref="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.Visit(System.Data.Entity.Core.Common.CommandTrees.DbFilterExpression)"/>, <see cref="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.Visit(System.Data.Entity.Core.Common.CommandTrees.DbGroupByExpression)"/>,
<see cref="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.Visit(System.Data.Entity.Core.Common.CommandTrees.DbProjectExpression)"/>, <see cref="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.Visit(System.Data.Entity.Core.Common.CommandTrees.DbSortExpression)"/> are similar.
Each does the following.
<list type="number">
<item>Visit the input expression</item>
<item>
Determine if the input's SQL statement can be reused, or a new
one must be created.
</item>
<item>Create a new symbol table scope</item>
<item>
Push the Sql statement onto a stack, so that children can
update the free variable list.
</item>
<item>Visit the non-input expression.</item>
<item>Cleanup</item>
</list>
</summary>
<returns>
A <see cref="T:System.Data.Entity.SqlServer.SqlGen.SqlSelectStatement"/>
</returns>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.Visit(System.Data.Entity.Core.Common.CommandTrees.DbFunctionExpression)">
<summary>
Lambda functions are not supported.
The functions supported are:
<list type="number">
<item>Canonical Functions - We recognize these by their dataspace, it is DataSpace.CSpace</item>
<item>Store Functions - We recognize these by the BuiltInAttribute and not being Canonical</item>
<item>User-defined Functions - All the rest</item>
</list>
We handle Canonical and Store functions the same way: If they are in the list of functions
that need special handling, we invoke the appropriate handler, otherwise we translate them to
FunctionName(arg1, arg2, ..., argn).
We translate user-defined functions to NamespaceName.FunctionName(arg1, arg2, ..., argn).
</summary>
<returns>
A <see cref="T:System.Data.Entity.SqlServer.SqlGen.SqlBuilder"/>
</returns>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.Visit(System.Data.Entity.Core.Common.CommandTrees.DbGroupByExpression)">
<summary>
<see cref="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.Visit(System.Data.Entity.Core.Common.CommandTrees.DbFilterExpression)"/> for general details.
We modify both the GroupBy and the Select fields of the SqlSelectStatement.
GroupBy gets just the keys without aliases,
and Select gets the keys and the aggregates with aliases.
Sql Server does not support arbitrarily complex expressions inside aggregates,
and requires keys to have reference to the input scope,
so in some cases we create a nested query in which we alias the arguments to the aggregates.
The exact limitations of Sql Server are:
<list type="number">
<item>
If an expression being aggregated contains an outer reference, then that outer
reference must be the only column referenced in the expression (SQLBUDT #488741)
</item>
<item>
Sql Server cannot perform an aggregate function on an expression containing
an aggregate or a subquery. (SQLBUDT #504600)
</item>
<item>
Sql Server requries each GROUP BY expression (key) to contain at least one column
that is not an outer reference. (SQLBUDT #616523)
</item>
<item>
Aggregates on the right side of an APPLY cannot reference columns from the left side.
(SQLBUDT #617683)
</item>
</list>
The default translation, without inner query is:
SELECT
kexp1 AS key1, kexp2 AS key2,... kexpn AS keyn,
aggf1(aexpr1) AS agg1, .. aggfn(aexprn) AS aggn
FROM input AS a
GROUP BY kexp1, kexp2, .. kexpn
When we inject an innner query, the equivalent translation is:
SELECT
key1 AS key1, key2 AS key2, .. keyn AS keys,
aggf1(agg1) AS agg1, aggfn(aggn) AS aggn
FROM (
SELECT
kexp1 AS key1, kexp2 AS key2,... kexpn AS keyn,
aexpr1 AS agg1, .. aexprn AS aggn
FROM input AS a
) as a
GROUP BY key1, key2, keyn
</summary>
<returns>
A <see cref="T:System.Data.Entity.SqlServer.SqlGen.SqlSelectStatement"/>
</returns>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.Visit(System.Data.Entity.Core.Common.CommandTrees.DbIntersectExpression)">
<summary>
<see cref="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.Visit(System.Data.Entity.Core.Common.CommandTrees.DbUnionAllExpression)"/>
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.Visit(System.Data.Entity.Core.Common.CommandTrees.DbIsEmptyExpression)">
<summary>
Not(IsEmpty) has to be handled specially, so we delegate to
<see cref="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.VisitIsEmptyExpression(System.Data.Entity.Core.Common.CommandTrees.DbIsEmptyExpression,System.Boolean)"/>.
</summary>
<returns>
A <see cref="T:System.Data.Entity.SqlServer.SqlGen.SqlBuilder"/> . <code>[NOT] EXISTS( ... )</code>
</returns>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.Visit(System.Data.Entity.Core.Common.CommandTrees.DbIsNullExpression)">
<summary>
Not(IsNull) is handled specially, so we delegate to
<see cref="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.VisitIsNullExpression(System.Data.Entity.Core.Common.CommandTrees.DbIsNullExpression,System.Boolean)"/>
</summary>
<returns>
A <see cref="T:System.Data.Entity.SqlServer.SqlGen.SqlBuilder"/> <code>IS [NOT] NULL</code>
</returns>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.Visit(System.Data.Entity.Core.Common.CommandTrees.DbIsOfExpression)">
<summary>
No error is raised if the store cannot support this.
</summary>
<returns>
A <see cref="T:System.Data.Entity.SqlServer.SqlGen.SqlBuilder"/>
</returns>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.Visit(System.Data.Entity.Core.Common.CommandTrees.DbCrossJoinExpression)">
<summary>
<see cref="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.VisitJoinExpression(System.Collections.Generic.IList{System.Data.Entity.Core.Common.CommandTrees.DbExpressionBinding},System.Data.Entity.Core.Common.CommandTrees.DbExpressionKind,System.String,System.Data.Entity.Core.Common.CommandTrees.DbExpression)"/>
</summary>
<returns>
A <see cref="T:System.Data.Entity.SqlServer.SqlGen.SqlSelectStatement"/> .
</returns>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.Visit(System.Data.Entity.Core.Common.CommandTrees.DbJoinExpression)">
<summary>
<see cref="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.VisitJoinExpression(System.Collections.Generic.IList{System.Data.Entity.Core.Common.CommandTrees.DbExpressionBinding},System.Data.Entity.Core.Common.CommandTrees.DbExpressionKind,System.String,System.Data.Entity.Core.Common.CommandTrees.DbExpression)"/>
</summary>
<returns>
A <see cref="T:System.Data.Entity.SqlServer.SqlGen.SqlSelectStatement"/> .
</returns>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.Visit(System.Data.Entity.Core.Common.CommandTrees.DbLikeExpression)">
<returns>
A <see cref="T:System.Data.Entity.SqlServer.SqlGen.SqlBuilder"/>
</returns>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.Visit(System.Data.Entity.Core.Common.CommandTrees.DbLimitExpression)">
<summary>
Translates to TOP expression. For Sql8, limit can only be a constant expression
</summary>
<returns>
A <see cref="T:System.Data.Entity.SqlServer.SqlGen.SqlBuilder"/>
</returns>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.Visit(System.Data.Entity.Core.Common.CommandTrees.DbNewInstanceExpression)">
<summary>
DbNewInstanceExpression is allowed as a child of DbProjectExpression only.
If anyone else is the parent, we throw.
We also perform special casing for collections - where we could convert
them into Unions
<see cref="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.VisitNewInstanceExpression(System.Data.Entity.Core.Common.CommandTrees.DbNewInstanceExpression,System.Boolean,System.Collections.Generic.Dictionary{System.String,System.Data.Entity.SqlServer.SqlGen.Symbol}@)"/> for the actual implementation.
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.Visit(System.Data.Entity.Core.Common.CommandTrees.DbNotExpression)">
<summary>
The Not expression may cause the translation of its child to change.
These children are
<list type="bullet">
<item>
<see cref="T:System.Data.Entity.Core.Common.CommandTrees.DbNotExpression"/>
NOT(Not(x)) becomes x
</item>
<item>
<see cref="T:System.Data.Entity.Core.Common.CommandTrees.DbIsEmptyExpression"/>
NOT EXISTS becomes EXISTS
</item>
<item>
<see cref="T:System.Data.Entity.Core.Common.CommandTrees.DbIsNullExpression"/>
IS NULL becomes IS NOT NULL
</item>
<item>
<see cref="T:System.Data.Entity.Core.Common.CommandTrees.DbComparisonExpression"/>
= becomes <>
</item>
</list>
</summary>
<returns>
A <see cref="T:System.Data.Entity.SqlServer.SqlGen.SqlBuilder"/>
</returns>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.Visit(System.Data.Entity.Core.Common.CommandTrees.DbNullExpression)">
<returns>
<see cref="T:System.Data.Entity.SqlServer.SqlGen.SqlBuilder"/>
</returns>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.Visit(System.Data.Entity.Core.Common.CommandTrees.DbOfTypeExpression)">
<returns>
A <see cref="T:System.Data.Entity.SqlServer.SqlGen.SqlBuilder"/>
</returns>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.Visit(System.Data.Entity.Core.Common.CommandTrees.DbOrExpression)">
<summary>
Visit a DbOrExpression and consider the subexpressions
for whether to generate OR conditions or an IN clause.
</summary>
<param name="e"> DbOrExpression to be visited </param>
<returns>
A <see cref="T:System.Data.Entity.SqlServer.SqlGen.SqlBuilder"/> fragment of SQL generated
</returns>
<seealso cref="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.Visit(System.Data.Entity.Core.Common.CommandTrees.DbAndExpression)"/>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.Visit(System.Data.Entity.Core.Common.CommandTrees.DbInExpression)">
<summary>
Visits a DbInExpression and generates the corresponding SQL fragment.
</summary>
<param name="e">
A <see cref="T:System.Data.Entity.Core.Common.CommandTrees.DbInExpression"/> that specifies the expression to be visited.
</param>
<returns>
A <see cref="T:System.Data.Entity.SqlServer.SqlGen.SqlBuilder"/> that specifies the generated SQL fragment.
</returns>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.TryTranslateIntoIn(System.Data.Entity.Core.Common.CommandTrees.DbOrExpression,System.Data.Entity.SqlServer.SqlGen.ISqlFragment@)">
<summary>
Determine if a DbOrExpression can be optimized into one or more IN clauses
and generate an ISqlFragment if it is possible.
</summary>
<param name="e"> DbOrExpression to attempt translation upon </param>
<param name="sqlFragment"> Fragment of SQL generated </param>
<returns> True if an IN clause is possible and sqlFragment has been generated, false otherwise </returns>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.IsKeyForIn(System.Data.Entity.Core.Common.CommandTrees.DbExpression)">
<summary>
Determines if a DbExpression is a valid key for the purposes of generating an In clause optimization.
</summary>
<param name="e"> DbExpression to consider </param>
<returns> True if the expression can be used as a key, false otherwise </returns>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.TryAddExpressionForIn(System.Data.Entity.Core.Common.CommandTrees.DbBinaryExpression,System.Collections.Generic.IDictionary{System.Data.Entity.Core.Common.CommandTrees.DbExpression,System.Collections.Generic.IList{System.Data.Entity.Core.Common.CommandTrees.DbExpression}})">
<summary>
Looks at both sides of a DbBinaryExpression to consider if either side is a valid candidate to
be a key and if so adds it to the KeyToListMap as a key with the other side as the value.
</summary>
<param name="e"> DbBinaryExpression to consider </param>
<param name="values"> KeyToListMap to add the sides of the binary expression to </param>
<returns> True if the expression was added, false otherwise </returns>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.HasBuiltMapForIn(System.Data.Entity.Core.Common.CommandTrees.DbExpression,System.Collections.Generic.IDictionary{System.Data.Entity.Core.Common.CommandTrees.DbExpression,System.Collections.Generic.IList{System.Data.Entity.Core.Common.CommandTrees.DbExpression}})">
<summary>
Attempts to build a KeyToListMap containing valid references and the appropriate value equality
tests associated with each so that they can be optimized into IN clauses. Calls itself recursively
to consider additional OR branches.
</summary>
<param name="e"> DbExpression representing the branch to evaluate </param>
<param name="values"> KeyToListMap to which to add references and value equality tests encountered </param>
<returns> True if this branch contained just equality tests or further OR branches, false otherwise </returns>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.Visit(System.Data.Entity.Core.Common.CommandTrees.DbParameterReferenceExpression)">
<summary>
This method handles the DBParameterReference expressions. If the parameter is in
a part of the tree, which matches our criteria for forcing to non-unicode, then
we add it to the list of candidate parameters. If the parameter occurs in a different
usage scenario, then disqualify it from being forced to non-unicode.
</summary>
<returns>
A <see cref="T:System.Data.Entity.SqlServer.SqlGen.SqlBuilder"/>
</returns>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.Visit(System.Data.Entity.Core.Common.CommandTrees.DbProjectExpression)">
<summary>
<see cref="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.Visit(System.Data.Entity.Core.Common.CommandTrees.DbFilterExpression)"/> for the general ideas.
</summary>
<returns>
A <see cref="T:System.Data.Entity.SqlServer.SqlGen.SqlSelectStatement"/>
</returns>
<seealso cref="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.Visit(System.Data.Entity.Core.Common.CommandTrees.DbFilterExpression)"/>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.Visit(System.Data.Entity.Core.Common.CommandTrees.DbPropertyExpression)">
<summary>
This method handles record flattening, which works as follows.
consider an expression <c>Prop(y, Prop(x, Prop(d, Prop(c, Prop(b, Var(a)))))</c>
where a,b,c are joins, d is an extent and x and y are fields.
b has been flattened into a, and has its own SELECT statement.
c has been flattened into b.
d has been flattened into c.
We visit the instance, so we reach Var(a) first. This gives us a (join)symbol.
Symbol(a).b gives us a join symbol, with a SELECT statement i.e. Symbol(b).
From this point on , we need to remember Symbol(b) as the source alias,
and then try to find the column. So, we use a SymbolPair.
We have reached the end when the symbol no longer points to a join symbol.
</summary>
<returns>
A <see cref="T:System.Data.Entity.SqlServer.SqlGen.JoinSymbol"/> if we have not reached the first Join node that has a SELECT statement. A
<see cref="T:System.Data.Entity.SqlServer.SqlGen.SymbolPair"/>
if we have seen the JoinNode, and it has a SELECT statement. A <see cref="T:System.Data.Entity.SqlServer.SqlGen.SqlBuilder"/> with {Input}.propertyName otherwise.
</returns>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.Visit(System.Data.Entity.Core.Common.CommandTrees.DbQuantifierExpression)">
<summary>
Any(input, x) => Exists(Filter(input,x))
All(input, x) => Not Exists(Filter(input, not(x))
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.Visit(System.Data.Entity.Core.Common.CommandTrees.DbSkipExpression)">
<summary>
For Sql9 it translates to:
SELECT Y.x1, Y.x2, ..., Y.xn
FROM (
SELECT X.x1, X.x2, ..., X.xn, row_number() OVER (ORDER BY sk1, sk2, ...) AS [row_number]
FROM input as X
) as Y
WHERE Y.[row_number] > count
ORDER BY sk1, sk2, ...
</summary>
<returns>
A <see cref="T:System.Data.Entity.SqlServer.SqlGen.SqlBuilder"/>
</returns>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.Visit(System.Data.Entity.Core.Common.CommandTrees.DbSortExpression)">
<summary>
<see cref="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.Visit(System.Data.Entity.Core.Common.CommandTrees.DbFilterExpression)"/>
</summary>
<returns>
A <see cref="T:System.Data.Entity.SqlServer.SqlGen.SqlSelectStatement"/>
</returns>
<seealso cref="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.Visit(System.Data.Entity.Core.Common.CommandTrees.DbFilterExpression)"/>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.Visit(System.Data.Entity.Core.Common.CommandTrees.DbTreatExpression)">
<returns>
A <see cref="T:System.Data.Entity.SqlServer.SqlGen.SqlBuilder"/>
</returns>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.Visit(System.Data.Entity.Core.Common.CommandTrees.DbUnionAllExpression)">
<summary>
This code is shared by <see cref="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.Visit(System.Data.Entity.Core.Common.CommandTrees.DbExceptExpression)"/>
and <see cref="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.Visit(System.Data.Entity.Core.Common.CommandTrees.DbIntersectExpression)"/>
<see cref="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.VisitSetOpExpression(System.Data.Entity.Core.Common.CommandTrees.DbExpression,System.Data.Entity.Core.Common.CommandTrees.DbExpression,System.String)"/>
Since the left and right expression may not be Sql select statements,
we must wrap them up to look like SQL select statements.
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.Visit(System.Data.Entity.Core.Common.CommandTrees.DbVariableReferenceExpression)">
<summary>
This method determines whether an extent from an outer scope(free variable)
is used in the CurrentSelectStatement.
An extent in an outer scope, if its symbol is not in the FromExtents
of the CurrentSelectStatement.
</summary>
<returns>
A <see cref="T:System.Data.Entity.SqlServer.SqlGen.Symbol"/> .
</returns>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.VisitAggregate(System.Data.Entity.Core.Common.CommandTrees.DbAggregate,System.Object)">
<summary>
Aggregates are not visited by the normal visitor walk.
</summary>
<param name="aggregate"> The aggregate go be translated </param>
<param name="aggregateArgument"> The translated aggregate argument </param>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.ParenthesizeExpressionIfNeeded(System.Data.Entity.Core.Common.CommandTrees.DbExpression,System.Data.Entity.SqlServer.SqlGen.SqlBuilder)">
<summary>
Dump out an expression - optionally wrap it with parantheses if possible
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.VisitBinaryExpression(System.String,System.Data.Entity.Core.Common.CommandTrees.DbExpressionKind,System.Data.Entity.Core.Common.CommandTrees.DbExpression,System.Data.Entity.Core.Common.CommandTrees.DbExpression)">
<summary>
Handler for inline binary expressions.
Produces left op right.
For associative operations does flattening.
Puts parenthesis around the arguments if needed.
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.FlattenAssociativeExpression(System.Data.Entity.Core.Common.CommandTrees.DbExpressionKind,System.Data.Entity.Core.Common.CommandTrees.DbExpression,System.Data.Entity.Core.Common.CommandTrees.DbExpression)">
<summary>
Creates a flat list of the associative arguments.
For example, for ((A1 + (A2 - A3)) + A4) it will create A1, (A2 - A3), A4
Only 'unfolds' the given arguments that are of the given expression kind.
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.ExtractAssociativeArguments(System.Data.Entity.Core.Common.CommandTrees.DbExpressionKind,System.Collections.Generic.List{System.Data.Entity.Core.Common.CommandTrees.DbExpression},System.Data.Entity.Core.Common.CommandTrees.DbExpression)">
<summary>
Helper method for FlattenAssociativeExpression.
Creates a flat list of the associative arguments and appends to the given argument list.
For example, for ((A1 + (A2 - A3)) + A4) it will add A1, (A2 - A3), A4 to the list.
Only 'unfolds' the given expression if it is of the given expression kind.
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.VisitComparisonExpression(System.String,System.Data.Entity.Core.Common.CommandTrees.DbExpression,System.Data.Entity.Core.Common.CommandTrees.DbExpression)">
<summary>
Private handler for comparison expressions - almost identical to VisitBinaryExpression.
We special case constants, so that we don't emit unnecessary casts
</summary>
<param name="op"> the comparison op </param>
<param name="left"> the left-side expression </param>
<param name="right"> the right-side expression </param>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.VisitInputExpression(System.Data.Entity.Core.Common.CommandTrees.DbExpression,System.String,System.Data.Entity.Core.Metadata.Edm.TypeUsage,System.Data.Entity.SqlServer.SqlGen.Symbol@)">
<summary>
This is called by the relational nodes. It does the following
<list>
<item>
If the input is not a SqlSelectStatement, it assumes that the input
is a collection expression, and creates a new SqlSelectStatement
</item>
</list>
</summary>
<returns>
A <see cref="T:System.Data.Entity.SqlServer.SqlGen.SqlSelectStatement"/> and the main fromSymbol for this select statement.
</returns>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.VisitIsEmptyExpression(System.Data.Entity.Core.Common.CommandTrees.DbIsEmptyExpression,System.Boolean)">
<summary>
<see cref="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.Visit(System.Data.Entity.Core.Common.CommandTrees.DbIsEmptyExpression)"/>
</summary>
<param name="e"> </param>
<param name="negate"> Was the parent a DbNotExpression? </param>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.VisitCollectionConstructor(System.Data.Entity.Core.Common.CommandTrees.DbNewInstanceExpression)">
<summary>
Translate a NewInstance(Element(X)) expression into
"select top(1) * from X"
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.VisitIsNullExpression(System.Data.Entity.Core.Common.CommandTrees.DbIsNullExpression,System.Boolean)">
<summary>
<see cref="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.Visit(System.Data.Entity.Core.Common.CommandTrees.DbIsNullExpression)"/>
</summary>
<param name="e"> </param>
<param name="negate"> Was the parent a DbNotExpression? </param>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.VisitJoinExpression(System.Collections.Generic.IList{System.Data.Entity.Core.Common.CommandTrees.DbExpressionBinding},System.Data.Entity.Core.Common.CommandTrees.DbExpressionKind,System.String,System.Data.Entity.Core.Common.CommandTrees.DbExpression)">
<summary>
This handles the processing of join expressions.
The extents on a left spine are flattened, while joins
not on the left spine give rise to new nested sub queries.
Joins work differently from the rest of the visiting, in that
the parent (i.e. the join node) creates the SqlSelectStatement
for the children to use.
The "parameter" IsInJoinContext indicates whether a child extent should
add its stuff to the existing SqlSelectStatement, or create a new SqlSelectStatement
By passing true, we ask the children to add themselves to the parent join,
by passing false, we ask the children to create new Select statements for
themselves.
This method is called from <see cref="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.Visit(System.Data.Entity.Core.Common.CommandTrees.DbApplyExpression)"/> and
<see cref="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.Visit(System.Data.Entity.Core.Common.CommandTrees.DbJoinExpression)"/>.
</summary>
<returns>
A <see cref="T:System.Data.Entity.SqlServer.SqlGen.SqlSelectStatement"/>
</returns>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.ProcessJoinInputResult(System.Data.Entity.SqlServer.SqlGen.ISqlFragment,System.Data.Entity.SqlServer.SqlGen.SqlSelectStatement,System.Data.Entity.Core.Common.CommandTrees.DbExpressionBinding,System.Int32)">
<summary>
This is called from <see cref="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.VisitJoinExpression(System.Collections.Generic.IList{System.Data.Entity.Core.Common.CommandTrees.DbExpressionBinding},System.Data.Entity.Core.Common.CommandTrees.DbExpressionKind,System.String,System.Data.Entity.Core.Common.CommandTrees.DbExpression)"/>.
This is responsible for maintaining the symbol table after visiting
a child of a join expression.
The child's sql statement may need to be completed.
The child's result could be one of
<list type="number">
<item>The same as the parent's - this is treated specially.</item>
<item>A sql select statement, which may need to be completed</item>
<item>An extent - just copy it to the from clause</item>
<item>
Anything else (from a collection-valued expression) -
unnest and copy it.
</item>
</list>
If the input was a Join, we need to create a new join symbol,
otherwise, we create a normal symbol.
We then call AddFromSymbol to add the AS clause, and update the symbol table.
If the child's result was the same as the parent's, we have to clean up
the list of symbols in the FromExtents list, since this contains symbols from
the children of both the parent and the child.
The happens when the child visited is a Join, and is the leftmost child of
the parent.
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.VisitNewInstanceExpression(System.Data.Entity.Core.Common.CommandTrees.DbNewInstanceExpression,System.Boolean,System.Collections.Generic.Dictionary{System.String,System.Data.Entity.SqlServer.SqlGen.Symbol}@)">
<summary>
We assume that this is only called as a child of a Project.
This replaces <see cref="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.Visit(System.Data.Entity.Core.Common.CommandTrees.DbNewInstanceExpression)"/>, since
we do not allow DbNewInstanceExpression as a child of any node other than
DbProjectExpression.
We write out the translation of each of the columns in the record.
</summary>
<returns>
A <see cref="T:System.Data.Entity.SqlServer.SqlGen.SqlBuilder"/>
</returns>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.VisitSetOpExpression(System.Data.Entity.Core.Common.CommandTrees.DbExpression,System.Data.Entity.Core.Common.CommandTrees.DbExpression,System.String)">
<summary>
Handler for set operations
It generates left separator right.
Only for SQL 8.0 it may need to create a new select statement
above the set operation if the left child's output columns got renamed
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.AddColumns(System.Data.Entity.SqlServer.SqlGen.SqlSelectStatement,System.Data.Entity.SqlServer.SqlGen.Symbol,System.Collections.Generic.List{System.Data.Entity.SqlServer.SqlGen.Symbol},System.Collections.Generic.Dictionary{System.String,System.Data.Entity.SqlServer.SqlGen.Symbol})">
<summary>
<see cref="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.AddDefaultColumns(System.Data.Entity.SqlServer.SqlGen.SqlSelectStatement)"/>
Add the column names from the referenced extent/join to the
select statement.
If the symbol is a JoinSymbol, we recursively visit all the extents,
halting at real extents and JoinSymbols that have an associated SqlSelectStatement.
The column names for a real extent can be derived from its type.
The column names for a Join Select statement can be got from the
list of columns that was created when the Join's select statement
was created.
We do the following for each column.
<list type="number">
<item>Add the SQL string for each column to the SELECT clause</item>
<item>
Add the column to the list of columns - so that it can
become part of the "type" of a JoinSymbol
</item>
<item>
Check if the column name collides with a previous column added
to the same select statement. Flag both the columns for renaming if true.
</item>
<item>Add the column to a name lookup dictionary for collision detection.</item>
</list>
</summary>
<param name="selectStatement"> The select statement that started off as SELECT * </param>
<param name="symbol"> The symbol containing the type information for the columns to be added. </param>
<param name="columnList">
Columns that have been added to the Select statement. This is created in
<see cref="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.AddDefaultColumns(System.Data.Entity.SqlServer.SqlGen.SqlSelectStatement)"/>
.
</param>
<param name="columnDictionary"> A dictionary of the columns above. </param>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.CreateOptionalColumn(System.Data.Entity.SqlServer.SqlGen.Symbol,System.Data.Entity.SqlServer.SqlGen.Symbol)">
<summary>
Creates an optional column and registers the corresponding symbol with
the optionalColumnUsageManager it has not already been registered.
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.AddColumn(System.Data.Entity.SqlServer.SqlGen.SqlSelectStatement,System.Data.Entity.SqlServer.SqlGen.Symbol,System.Collections.Generic.List{System.Data.Entity.SqlServer.SqlGen.Symbol},System.Collections.Generic.Dictionary{System.String,System.Data.Entity.SqlServer.SqlGen.Symbol},System.String)">
<summary>
Helper method for AddColumns. Adds a column with the given column name
to the Select list of the given select statement.
</summary>
<param name="selectStatement"> The select statement to whose SELECT part the column should be added </param>
<param name="symbol"> The symbol from which the column to be added originated </param>
<param name="columnList">
Columns that have been added to the Select statement. This is created in
<see cref="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.AddDefaultColumns(System.Data.Entity.SqlServer.SqlGen.SqlSelectStatement)"/>
.
</param>
<param name="columnDictionary"> A dictionary of the columns above. </param>
<param name="columnName"> The name of the column to be added. </param>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.AddDefaultColumns(System.Data.Entity.SqlServer.SqlGen.SqlSelectStatement)">
<summary>
Expands Select * to "select the_list_of_columns"
If the columns are taken from an extent, they are written as
{original_column_name AS Symbol(original_column)} to allow renaming.
If the columns are taken from a Join, they are written as just
{original_column_name}, since there cannot be a name collision.
We concatenate the columns from each of the inputs to the select statement.
Since the inputs may be joins that are flattened, we need to recurse.
The inputs are inferred from the symbols in FromExtents.
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.AddFromSymbol(System.Data.Entity.SqlServer.SqlGen.SqlSelectStatement,System.String,System.Data.Entity.SqlServer.SqlGen.Symbol)">
<summary>
<see cref="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.AddFromSymbol(System.Data.Entity.SqlServer.SqlGen.SqlSelectStatement,System.String,System.Data.Entity.SqlServer.SqlGen.Symbol,System.Boolean)"/>
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.AddFromSymbol(System.Data.Entity.SqlServer.SqlGen.SqlSelectStatement,System.String,System.Data.Entity.SqlServer.SqlGen.Symbol,System.Boolean)">
<summary>
This method is called after the input to a relational node is visited.
<see cref="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.Visit(System.Data.Entity.Core.Common.CommandTrees.DbProjectExpression)"/> and <see cref="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.ProcessJoinInputResult(System.Data.Entity.SqlServer.SqlGen.ISqlFragment,System.Data.Entity.SqlServer.SqlGen.SqlSelectStatement,System.Data.Entity.Core.Common.CommandTrees.DbExpressionBinding,System.Int32)"/>
There are 2 scenarios
<list type="number">
<item>
The fromSymbol is new i.e. the select statement has just been
created, or a join extent has been added.
</item>
<item>The fromSymbol is old i.e. we are reusing a select statement.</item>
</list>
If we are not reusing the select statement, we have to complete the
FROM clause with the alias
<code>-- if the input was an extent
FROM = [SchemaName].[TableName]
-- if the input was a Project
FROM = (SELECT ... FROM ... WHERE ...)</code>
These become
<code>-- if the input was an extent
FROM = [SchemaName].[TableName] AS alias
-- if the input was a Project
FROM = (SELECT ... FROM ... WHERE ...) AS alias</code>
and look like valid FROM clauses.
Finally, we have to add the alias to the global list of aliases used,
and also to the current symbol table.
</summary>
<param name="selectStatement"> </param>
<param name="inputVarName"> The alias to be used. </param>
<param name="fromSymbol"> </param>
<param name="addToSymbolTable"> </param>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.AddSortKeys(System.Data.Entity.SqlServer.SqlGen.SqlBuilder,System.Collections.Generic.IList{System.Data.Entity.Core.Common.CommandTrees.DbSortClause})">
<summary>
Translates a list of SortClauses.
Used in the translation of OrderBy
</summary>
<param name="orderByClause"> The SqlBuilder to which the sort keys should be appended </param>
<param name="sortKeys"> </param>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.CreateNewSelectStatement(System.Data.Entity.SqlServer.SqlGen.SqlSelectStatement,System.String,System.Data.Entity.Core.Metadata.Edm.TypeUsage,System.Data.Entity.SqlServer.SqlGen.Symbol@)">
<summary>
<see cref="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.CreateNewSelectStatement(System.Data.Entity.SqlServer.SqlGen.SqlSelectStatement,System.String,System.Data.Entity.Core.Metadata.Edm.TypeUsage,System.Boolean,System.Data.Entity.SqlServer.SqlGen.Symbol@)"/>
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.CreateNewSelectStatement(System.Data.Entity.SqlServer.SqlGen.SqlSelectStatement,System.String,System.Data.Entity.Core.Metadata.Edm.TypeUsage,System.Boolean,System.Data.Entity.SqlServer.SqlGen.Symbol@)">
<summary>
This is called after a relational node's input has been visited, and the
input's sql statement cannot be reused. <see cref="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.Visit(System.Data.Entity.Core.Common.CommandTrees.DbProjectExpression)"/>
When the input's sql statement cannot be reused, we create a new sql
statement, with the old one as the from clause of the new statement.
The old statement must be completed i.e. if it has an empty select list,
the list of columns must be projected out.
If the old statement being completed has a join symbol as its from extent,
the new statement must have a clone of the join symbol as its extent.
We cannot reuse the old symbol, but the new select statement must behave
as though it is working over the "join" record.
</summary>
<returns> A new select statement, with the old one as the from clause. </returns>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.EscapeSingleQuote(System.String,System.Boolean)">
<summary>
Before we embed a string literal in a SQL string, we should
convert all ' to '', and enclose the whole string in single quotes.
</summary>
<returns> The escaped sql string. </returns>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.GetSqlPrimitiveType(System.Data.Entity.Core.Metadata.Edm.TypeUsage)">
<summary>
Returns the sql primitive/native type name.
It will include size, precision or scale depending on type information present in the
type facets
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.HandleCountExpression(System.Data.Entity.Core.Common.CommandTrees.DbExpression)">
<summary>
Handles the expression represending DbLimitExpression.Limit and DbSkipExpression.Count.
If it is a constant expression, it simply does to string thus avoiding casting it to the specific value
(which would be done if <see cref="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.Visit(System.Data.Entity.Core.Common.CommandTrees.DbConstantExpression)"/> is called)
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.IsApplyExpression(System.Data.Entity.Core.Common.CommandTrees.DbExpression)">
<summary>
This is used to determine if a particular expression is an Apply operation.
This is only the case when the DbExpressionKind is CrossApply or OuterApply.
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.IsJoinExpression(System.Data.Entity.Core.Common.CommandTrees.DbExpression)">
<summary>
This is used to determine if a particular expression is a Join operation.
This is true for DbCrossJoinExpression and DbJoinExpression, the
latter of which may have one of several different ExpressionKinds.
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.IsComplexExpression(System.Data.Entity.Core.Common.CommandTrees.DbExpression)">
<summary>
This is used to determine if a calling expression needs to place
round brackets around the translation of the expression e.
Constants, parameters and properties do not require brackets,
everything else does.
</summary>
<returns> true, if the expression needs brackets </returns>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.IsCompatible(System.Data.Entity.SqlServer.SqlGen.SqlSelectStatement,System.Data.Entity.Core.Common.CommandTrees.DbExpressionKind)">
<summary>
Determine if the owner expression can add its unique sql to the input's
SqlSelectStatement
</summary>
<param name="result"> The SqlSelectStatement of the input to the relational node. </param>
<param name="expressionKind"> The kind of the expression node(not the input's) </param>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.QuoteIdentifier(System.String)">
<summary>
We use the normal box quotes for SQL server. We do not deal with ANSI quotes
i.e. double quotes.
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.VisitExpressionEnsureSqlStatement(System.Data.Entity.Core.Common.CommandTrees.DbExpression)">
<summary>
Simply calls <see cref="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.VisitExpressionEnsureSqlStatement(System.Data.Entity.Core.Common.CommandTrees.DbExpression,System.Boolean,System.Boolean)"/>
with addDefaultColumns set to true and markAllDefaultColumnsAsUsed set to false.
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.VisitExpressionEnsureSqlStatement(System.Data.Entity.Core.Common.CommandTrees.DbExpression,System.Boolean,System.Boolean)">
<summary>
This is called from <see cref="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.GenerateSql(System.Data.Entity.Core.Common.CommandTrees.DbQueryCommandTree,System.Collections.Generic.HashSet{System.String}@)"/>
and nodes which require a select statement as an argument e.g. <see cref="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.Visit(System.Data.Entity.Core.Common.CommandTrees.DbIsEmptyExpression)"/>,
<see cref="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.Visit(System.Data.Entity.Core.Common.CommandTrees.DbUnionAllExpression)"/>.
SqlGenerator needs its child to have a proper alias if the child is
just an extent or a join.
The normal relational nodes result in complete valid SQL statements.
For the rest, we need to treat them as there was a dummy
<code>-- originally {expression}
-- change that to
SELECT *
FROM {expression} as c</code>
DbLimitExpression needs to start the statement but not add the default columns
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.VisitFilterExpression(System.Data.Entity.Core.Common.CommandTrees.DbExpressionBinding,System.Data.Entity.Core.Common.CommandTrees.DbExpression,System.Boolean)">
<summary>
This method is called by <see cref="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.Visit(System.Data.Entity.Core.Common.CommandTrees.DbFilterExpression)"/> and
<see cref="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.Visit(System.Data.Entity.Core.Common.CommandTrees.DbQuantifierExpression)"/>
</summary>
<param name="input"> </param>
<param name="predicate"> </param>
<param name="negatePredicate">
This is passed from <see cref="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.Visit(System.Data.Entity.Core.Common.CommandTrees.DbQuantifierExpression)"/> in the All(...) case.
</param>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.WrapNonQueryExtent(System.Data.Entity.SqlServer.SqlGen.SqlSelectStatement,System.Data.Entity.SqlServer.SqlGen.ISqlFragment,System.Data.Entity.Core.Common.CommandTrees.DbExpressionKind)">
<summary>
If the sql fragment for an input expression is not a SqlSelect statement
or other acceptable form (e.g. an extent as a SqlBuilder), we need
to wrap it in a form acceptable in a FROM clause. These are
primarily the
<list type="bullet">
<item>The set operation expressions - union all, intersect, except</item>
<item>TVFs, which are conceptually similar to tables</item>
</list>
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.GroupByAggregatesNeedInnerQuery(System.Collections.Generic.IList{System.Data.Entity.Core.Common.CommandTrees.DbAggregate},System.String)">
<summary>
Helper method for the Group By visitor
Returns true if at least one of the aggregates in the given list
has an argument that is not a <see cref="T:System.Data.Entity.Core.Common.CommandTrees.DbConstantExpression"/> and is not
a <see cref="T:System.Data.Entity.Core.Common.CommandTrees.DbPropertyExpression"/> over <see cref="T:System.Data.Entity.Core.Common.CommandTrees.DbVariableReferenceExpression"/>,
either potentially capped with a <see cref="T:System.Data.Entity.Core.Common.CommandTrees.DbCastExpression"/>
This is really due to the following two limitations of Sql Server:
<list type="number">
<item>
If an expression being aggregated contains an outer reference, then that outer
reference must be the only column referenced in the expression (SQLBUDT #488741)
</item>
<item>
Sql Server cannot perform an aggregate function on an expression containing
an aggregate or a subquery. (SQLBUDT #504600)
</item>
</list>
Potentially, we could furhter optimize this.
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.GroupByAggregateNeedsInnerQuery(System.Data.Entity.Core.Common.CommandTrees.DbExpression,System.String)">
<summary>
Returns true if the given expression is not a <see cref="T:System.Data.Entity.Core.Common.CommandTrees.DbConstantExpression"/> or a
<see cref="T:System.Data.Entity.Core.Common.CommandTrees.DbPropertyExpression"/> over a <see cref="T:System.Data.Entity.Core.Common.CommandTrees.DbVariableReferenceExpression"/>
referencing the given inputVarRefName, either
potentially capped with a <see cref="T:System.Data.Entity.Core.Common.CommandTrees.DbCastExpression"/>.
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.GroupByKeysNeedInnerQuery(System.Collections.Generic.IList{System.Data.Entity.Core.Common.CommandTrees.DbExpression},System.String)">
<summary>
Helper method for the Group By visitor
Returns true if at least one of the expressions in the given list
is not <see cref="T:System.Data.Entity.Core.Common.CommandTrees.DbPropertyExpression"/> over <see cref="T:System.Data.Entity.Core.Common.CommandTrees.DbVariableReferenceExpression"/>
referencing the given inputVarRefName potentially capped with a <see cref="T:System.Data.Entity.Core.Common.CommandTrees.DbCastExpression"/>.
This is really due to the following limitation: Sql Server requires each GROUP BY expression
(key) to contain at least one column that is not an outer reference. (SQLBUDT #616523)
Potentially, we could further optimize this.
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.GroupByKeyNeedsInnerQuery(System.Data.Entity.Core.Common.CommandTrees.DbExpression,System.String)">
<summary>
Returns true if the given expression is not <see cref="T:System.Data.Entity.Core.Common.CommandTrees.DbPropertyExpression"/> over
<see cref="T:System.Data.Entity.Core.Common.CommandTrees.DbVariableReferenceExpression"/> referencing the given inputVarRefName
potentially capped with a <see cref="T:System.Data.Entity.Core.Common.CommandTrees.DbCastExpression"/>.
This is really due to the following limitation: Sql Server requires each GROUP BY expression
(key) to contain at least one column that is not an outer reference. (SQLBUDT #616523)
Potentially, we could further optimize this.
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.GroupByExpressionNeedsInnerQuery(System.Data.Entity.Core.Common.CommandTrees.DbExpression,System.String,System.Boolean)">
<summary>
Helper method for processing Group By keys and aggregates.
Returns true if the given expression is not a <see cref="T:System.Data.Entity.Core.Common.CommandTrees.DbConstantExpression"/>
(and allowConstants is specified)or a <see cref="T:System.Data.Entity.Core.Common.CommandTrees.DbPropertyExpression"/> over
a <see cref="T:System.Data.Entity.Core.Common.CommandTrees.DbVariableReferenceExpression"/> referencing the given inputVarRefName,
either potentially capped with a <see cref="T:System.Data.Entity.Core.Common.CommandTrees.DbCastExpression"/>.
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.AssertKatmaiOrNewer(System.Data.Entity.Core.Metadata.Edm.PrimitiveTypeKind)">
<summary>
Throws not supported exception if the server is pre-katmai
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.AssertKatmaiOrNewer(System.Data.Entity.Core.Common.CommandTrees.DbFunctionExpression)">
<summary>
Throws not supported exception if the server is pre-katmai
</summary>
</member>
<member name="P:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.CurrentSelectStatement">
<summary>
The top of the stack
</summary>
</member>
<member name="P:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.IsParentAJoin">
<summary>
Determine if the parent is a join.
</summary>
</member>
<member name="T:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.KeyFieldExpressionComparer">
<summary>
Required by the KeyToListMap to allow certain DbExpression subclasses to be used as a key
which is not normally possible given their lack of Equals and GetHashCode implementations
for testing object value equality.
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.KeyFieldExpressionComparer.Equals(System.Data.Entity.Core.Common.CommandTrees.DbExpression,System.Data.Entity.Core.Common.CommandTrees.DbExpression)">
<summary>
Compare two DbExpressions to see if they are equal for the purposes of
our key management. We only support DbPropertyExpression, DbParameterReferenceExpression,
VariableReferenceExpression and DbCastExpression types. Everything else will fail to
be considered equal.
</summary>
<param name="x"> First DbExpression to consider for equality </param>
<param name="y"> Second DbExpression to consider for equality </param>
<returns> True if the types are allowed and equal, false otherwise </returns>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.KeyFieldExpressionComparer.GetHashCode(System.Data.Entity.Core.Common.CommandTrees.DbExpression)">
<summary>
Calculates a hashcode for a given number of DbExpression subclasses to allow the KeyToListMap
to efficiently and reliably locate existing keys.
</summary>
<param name="obj"> DbExpression to calculate a hashcode for </param>
<returns> Integer containing the hashcode </returns>
</member>
<member name="T:System.Data.Entity.SqlServer.SqlGen.SqlSelectClauseBuilder">
<summary>
This class is used for building the SELECT clause of a Sql Statement
It is used to gather information about required and optional columns
and whether TOP and DISTINCT should be specified.
The underlying SqlBuilder is used for gathering the required columns.
The list of OptionalColumns is used for gathering the optional columns.
Whether a given OptionalColumn should be written is known only after the entire
command tree has been processed.
The IsDistinct property indicates that we want distinct columns.
This is given out of band, since the input expression to the select clause
may already have some columns projected out, and we use append-only SqlBuilders.
The DISTINCT is inserted when we finally write the object into a string.
Also, we have a Top property, which is non-null if the number of results should
be limited to certain number. It is given out of band for the same reasons as DISTINCT.
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlSelectClauseBuilder.WriteSql(System.Data.Entity.SqlServer.SqlGen.SqlWriter,System.Data.Entity.SqlServer.SqlGen.SqlGenerator)">
<summary>
Writes the string representing the Select statement:
SELECT (DISTINCT) (TOP topClause) (optionalColumns) (requiredColumns)
If Distinct is specified or this is part of a top most statement
all optional columns are marked as used.
Optional columns are only written if marked as used.
In addition, if no required columns are specified and no optional columns are
marked as used, the first optional column is written.
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlSelectClauseBuilder.WriteOptionalColumns(System.Data.Entity.SqlServer.SqlGen.SqlWriter,System.Data.Entity.SqlServer.SqlGen.SqlGenerator)">
<summary>
Writes the optional columns that are used.
If this is the topmost statement or distict is specifed as part of the same statement
all optoinal columns are written.
</summary>
<returns> Whether at least one column got written </returns>
</member>
<member name="P:System.Data.Entity.SqlServer.SqlGen.SqlSelectClauseBuilder.IsDistinct">
<summary>
Do we need to add a DISTINCT at the beginning of the SELECT
</summary>
</member>
<member name="P:System.Data.Entity.SqlServer.SqlGen.SqlSelectClauseBuilder.IsEmpty">
<summary>
Whether any columns have been specified.
</summary>
</member>
<member name="T:System.Data.Entity.SqlServer.SqlGen.SqlSelectStatement">
<summary>
A SqlSelectStatement represents a canonical SQL SELECT statement.
It has fields for the 5 main clauses
<list type="number">
<item>SELECT</item>
<item>FROM</item>
<item>WHERE</item>
<item>GROUP BY</item>
<item>ORDER BY</item>
</list>
We do not have HAVING, since the CQT does not have such a node.
Each of the fields is a SqlBuilder, so we can keep appending SQL strings
or other fragments to build up the clause.
The FromExtents contains the list of inputs in use for the select statement.
There is usually just one element in this - Select statements for joins may
temporarily have more than one.
If the select statement is created by a Join node, we maintain a list of
all the extents that have been flattened in the join in AllJoinExtents
<example>
in J(j1= J(a,b), c)
FromExtents has 2 nodes JoinSymbol(name=j1, ...) and Symbol(name=c)
AllJoinExtents has 3 nodes Symbol(name=a), Symbol(name=b), Symbol(name=c)
</example>
If any expression in the non-FROM clause refers to an extent in a higher scope,
we add that extent to the OuterExtents list. This list denotes the list
of extent aliases that may collide with the aliases used in this select statement.
It is set by <see cref="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.Visit(System.Data.Entity.Core.Common.CommandTrees.DbVariableReferenceExpression)"/>.
An extent is an outer extent if it is not one of the FromExtents.
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.SqlSelectStatement.WriteSql(System.Data.Entity.SqlServer.SqlGen.SqlWriter,System.Data.Entity.SqlServer.SqlGen.SqlGenerator)">
<summary>
Write out a SQL select statement as a string.
We have to
<list type="number">
<item>
Check whether the aliases extents we use in this statement have
to be renamed.
We first create a list of all the aliases used by the outer extents.
For each of the FromExtents( or AllJoinExtents if it is non-null),
rename it if it collides with the previous list.
</item>
<item>Write each of the clauses (if it exists) as a string</item>
</list>
</summary>
</member>
<member name="P:System.Data.Entity.SqlServer.SqlGen.SqlSelectStatement.OutputColumnsRenamed">
<summary>
Whether the columns ouput by this sql statement were renamed from what given in the command tree.
</summary>
</member>
<member name="P:System.Data.Entity.SqlServer.SqlGen.SqlSelectStatement.OutputColumns">
<summary>
A dictionary of output columns
</summary>
</member>
<member name="T:System.Data.Entity.SqlServer.SqlGen.SqlWriter">
<summary>
This extends IndentedTextWriter/StringWriter primarily to add the ability to add an indent
to each line that is written out.
</summary>
</member>
<member name="T:System.Data.Entity.SqlServer.SqlGen.SymbolPair">
<summary>
The SymbolPair exists to solve the record flattening problem.
<see cref="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.Visit(System.Data.Entity.Core.Common.CommandTrees.DbPropertyExpression)"/>
Consider a property expression D(v, "j3.j2.j1.a.x")
where v is a VarRef, j1, j2, j3 are joins, a is an extent and x is a columns.
This has to be translated eventually into {j'}.{x'}
The source field represents the outermost SqlStatement representing a join
expression (say j2) - this is always a Join symbol.
The column field keeps moving from one join symbol to the next, until it
stops at a non-join symbol.
This is returned by <see cref="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.Visit(System.Data.Entity.Core.Common.CommandTrees.DbPropertyExpression)"/>,
but never makes it into a SqlBuilder.
</summary>
</member>
<member name="T:System.Data.Entity.SqlServer.SqlGen.SymbolTable">
<summary>
The symbol table is quite primitive - it is a stack with a new entry for
each scope. Lookups search from the top of the stack to the bottom, until
an entry is found.
The symbols are of the following kinds
<list type="bullet">
<item>
<see cref="T:System.Data.Entity.SqlServer.SqlGen.Symbol"/>
represents tables (extents/nested selects/unnests)
</item>
<item>
<see cref="T:System.Data.Entity.SqlServer.SqlGen.JoinSymbol"/>
represents Join nodes
</item>
<item>
<see cref="T:System.Data.Entity.SqlServer.SqlGen.Symbol"/>
columns.
</item>
</list>
Symbols represent names <see cref="M:System.Data.Entity.SqlServer.SqlGen.SqlGenerator.Visit(System.Data.Entity.Core.Common.CommandTrees.DbVariableReferenceExpression)"/> to be resolved,
or things to be renamed.
</summary>
</member>
<member name="T:System.Data.Entity.SqlServer.SqlGen.SymbolUsageManager">
<summary>
Tracks the usage of symbols.
When registering a symbol with the usage manager if an input symbol is specified,
than the usage of the two is 'connected' - if one ever gets marked as used,
the other one becomes 'used' too.
</summary>
</member>
<member name="T:System.Data.Entity.SqlServer.SqlGen.TopClause">
<summary>
TopClause represents the a TOP expression in a SqlSelectStatement.
It has a count property, which indicates how many TOP rows should be selected and a
boolen WithTies property.
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.TopClause.#ctor(System.Data.Entity.SqlServer.SqlGen.ISqlFragment,System.Boolean)">
<summary>
Creates a TopClause with the given topCount and withTies.
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.TopClause.#ctor(System.Int32,System.Boolean)">
<summary>
Creates a TopClause with the given topCount and withTies.
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlGen.TopClause.WriteSql(System.Data.Entity.SqlServer.SqlGen.SqlWriter,System.Data.Entity.SqlServer.SqlGen.SqlGenerator)">
<summary>
Write out the TOP part of sql select statement
It basically writes TOP (X) [WITH TIES].
The brackets around X are ommited for Sql8.
</summary>
</member>
<member name="P:System.Data.Entity.SqlServer.SqlGen.TopClause.WithTies">
<summary>
Do we need to add a WITH_TIES to the top statement
</summary>
</member>
<member name="P:System.Data.Entity.SqlServer.SqlGen.TopClause.TopCount">
<summary>
How many top rows should be selected.
</summary>
</member>
<member name="T:System.Data.Entity.SqlServer.SqlProviderManifest">
<summary>
The Provider Manifest for SQL Server
</summary>
</member>
<member name="F:System.Data.Entity.SqlServer.SqlProviderManifest.varcharMaxSize">
<summary>
Maximum size of SQL Server unicode
</summary>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlProviderManifest.#ctor(System.String)">
<summary>
Initializes a new instance of the <see cref="T:System.Data.Entity.SqlServer.SqlProviderManifest"/> class.
</summary>
<param name="manifestToken"> A token used to infer the capabilities of the store. </param>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlProviderManifest.EscapeLikeText(System.String,System.Boolean,System.Boolean@)">
<summary>
Function to detect wildcard characters %, _, [ and ^ and escape them with a preceding ~
This escaping is used when StartsWith, EndsWith and Contains canonical and CLR functions
are translated to their equivalent LIKE expression
NOTE: This code has been copied from LinqToSql
</summary>
<param name="text"> Original input as specified by the user </param>
<param name="alwaysEscapeEscapeChar"> escape the escape character ~ regardless whether wildcard characters were encountered </param>
<param name="usedEscapeChar"> true if the escaping was performed, false if no escaping was required </param>
<returns> The escaped string that can be used as pattern in a LIKE expression </returns>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlProviderManifest.GetDbInformation(System.String)">
<summary>
Providers should override this to return information specific to their provider.
This method should never return null.
</summary>
<param name="informationType"> The name of the information to be retrieved. </param>
<returns> An XmlReader at the begining of the information requested. </returns>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlProviderManifest.GetEdmType(System.Data.Entity.Core.Metadata.Edm.TypeUsage)">
<summary>
This method takes a type and a set of facets and returns the best mapped equivalent type
in EDM.
</summary>
<param name="storeType"> A TypeUsage encapsulating a store type and a set of facets </param>
<returns> A TypeUsage encapsulating an EDM type and a set of facets </returns>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlProviderManifest.GetStoreType(System.Data.Entity.Core.Metadata.Edm.TypeUsage)">
<summary>
This method takes a type and a set of facets and returns the best mapped equivalent type
in SQL Server, taking the store version into consideration.
</summary>
<param name="edmType"> A TypeUsage encapsulating an EDM type and a set of facets </param>
<returns> A TypeUsage encapsulating a store type and a set of facets </returns>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlProviderManifest.SupportsEscapingLikeArgument(System.Char@)">
<summary>
Returns true, SqlClient supports escaping strings to be used as arguments to like
The escape character is '~'
</summary>
<param name="escapeCharacter"> The character '~' </param>
<returns> True </returns>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlProviderManifest.EscapeLikeArgument(System.String)">
<summary>
Escapes the wildcard characters and the escape character in the given argument.
</summary>
<returns> Equivalent to the argument, with the wildcard characters and the escape character escaped </returns>
</member>
<member name="M:System.Data.Entity.SqlServer.SqlProviderManifest.SupportsInExpression">
<summary>
Returns a boolean that specifies whether the corresponding provider can handle expression trees
containing instances of DbInExpression.
The Sql provider handles instances of DbInExpression.
</summary>
<returns> <c>true</c>. </returns>
</member>
<member name="T:System.Data.Entity.SqlServer.SqlProviderServices">
<summary>
The DbProviderServices implementation for the SqlClient provider for SQL Server.
</summary>
<remarks>
Note that instance of this type also resolve additional provider services for Microsoft SQL Server
when this type is registered as an EF provider either using an entry in the application's config file
|