public SubscriberModel[] GetSubscriberProviders(long subscriberId) { using (var db = GetDBConnect()) { var subscribers = from signalSubscriber in db.signal_subscribers join subscription in db.signal_subscriptions on signalSubscriber.id equals subscription.account_slave_id into subscriptionNull from subscription in Enumerable.DefaultIfEmpty(subscriptionNull) join provider in db.signal_providers on subscription.account_master_id equals provider.id into providerNull from provider in Enumerable.DefaultIfEmpty(providerNull) where signalSubscriber.id == subscriberId && subscription != null && (subscription.status == (short)SubscriptionStatus.On || subscription.status == (short)SubscriptionStatus.CloseOnly) select new SubscriberModel { Subscriber = signalSubscriber, Subscription = subscription, Provider = provider }; return(subscribers.ToArray()); } }
public ProviderModel[] GetDeliveries(long clientId) { using (var db = GetDBConnect()) { var providers = from signalProvider in db.signal_providers join subscription in db.signal_subscriptions on signalProvider.id equals subscription.account_master_id into subscriptionNull from subscription in Enumerable.DefaultIfEmpty(subscriptionNull) join subscriber in db.signal_subscribers on subscription.account_slave_id equals subscriber.id into subscriberNull from subscriber in Enumerable.DefaultIfEmpty(subscriberNull) where signalProvider.client_account_id == clientId && (subscription == null || subscription.status == (short)SubscriptionStatus.On || subscription.status == (short)SubscriptionStatus.CloseOnly) && !signalProvider.isdeleted select new ProviderModel { Provider = signalProvider, Subscription = subscription, Subscriber = subscriber }; return(providers.ToArray()); } }
public void BlinqShouldEqualLinqNativeArrayDefaultIfEmpty([ArrayValues] int[] sourceArr) { var source = new NativeArray <int>(sourceArr, Allocator.Persistent); var expected = ExceptionAndValue(() => Linq.ToArray(Linq.DefaultIfEmpty(source, 1))); var actual = ExceptionAndValue(() => Linq.ToArray(source.DefaultIfEmpty(1))); AssertAreEqual(expected, actual); source.Dispose(); }
public static IEnumerable <TSource> DefaultIfEmpty <TSource>(this IEnumerable <TSource> source, TSource defaultValue) => LinqEnumerable.DefaultIfEmpty(source, defaultValue);
public static IEnumerable <TSource> DefaultIfEmpty <TSource>(this IEnumerable <TSource> source) => Enumerable.DefaultIfEmpty(source);