Posts

Showing posts from February, 2018

Dynamic Query in LINQ using Predicate Builder

IntroductionThis tutorial explains how to create a dynamic query using LINQ, Using Predicate Builder  LINQ to SQL dynamic query and Query with Entity Framework is easy. This concept first implement by albahari DescriptionPredicate Builder is powerful LINQ expression which is mainly used when too many search filter parameter is there for querying data by writing dynamic query expression. We can write a query like Dynamic SQL.
To know more about predicate delegate visit Predicate Delegate How To Implement Predicate Builder
In this example, I have created an instance of PredicateBuilder with PatientInfo Model and add multiple OR and AND Condition based on their value. Predicate Builder automatically creates a dynamic query with Linq and combined into one Expression.
dynamic-linq-sample.cs



When We have a grid which filters record based on applied filter and filter parameter is in large number decision of use Dynamic LINQ result very high performance and minimize code writing while implementati…

Connect to TFS using CSharp

Login using Google API with C#

Image
Introduction
In this article, we learn about how to login using Google OAuth 2.0 with C#(.NET) or Authenticate Google API in Dot Net.

DescriptionAs we know Google OAuth 2.0 requires ClientId and ClientSecret before we proceeding to further step. So, first of all, we have to generate ClientId and ClientSecret from Google Developer Console by creating credential or generating a credential for Web Application or from Native Application.
I hope you have google account already if not then first create one before proceeding further.
Step 1: Create Credential for OAuth App. Step 2: Select appropriate application type from the available option, Here I have choosed "Other".
Based on where we are using login with google account we can select an application type. Here I have used "other" which works for a console app, Web application hosted on localhost as well as on all domain custom as well as localhost.
Step 3: Copy and save generate ClientId and Client Secret

Now, you have your C…