IQueryWhereBuilder.Where(string left, string right) Method

.NET Standard 2.x

Creates a WHERE clause, and adds a search condition to the WHERE clause. Specifies SQL expressions on both the left and right of the operator. The operator is '='.

Namespace: SnapObjects.Data

Assembly: SnapObjects.Data.dll

Syntax

IQueryAndOrBuilder<TModel> Where(string left, string right);

Parameters

left System.String

A SQL expression on the left of the operator.

right System.String

A SQL expression on the right of the operator.

Returns

IQueryAndOrBuilder<TModel>

Returns an IQueryAndOrBuilder<TModel> object which can be used to add more search conditions to the current WHERE clause.

Examples

The following code example uses the Where method to specify the column.

using Appeon.ApiDoc.Models.School;
using SnapObjects.Data;
using System;
using System.Threading.Tasks;

namespace Appeon.ApiDoc.IQueryWhereBuilderExamples
{
    public class WhereExample
    {
        private SchoolContext _context;
        
        public WhereExample(SchoolContext dataContext)
        {
            // Sets Data Context
            _context = dataContext;
        }

        public async Task<int> Example1() 
        {
            // Get a QueryBuilder.
            var Builder = _context.SqlModelMapper.GetQueryBuilder<Person>();
            
            // Creates a WHERE clause, and adds a search condition to the WHERE clause.
            // Specifies SQL expressions on both the left and right of the operator. 
            // The operator is '='.
            Builder.Where("FirstName", "LastName");
            
            var result = (await Builder.LoadAsync()).ToList();
            
            foreach (var person in result)
            {
                Console.WriteLine("PersonID:    {0}", person.PersonID);
                Console.WriteLine("FirstName:   {0}", person.FirstName);
                Console.WriteLine("LastName:    {0}", person.LastName);
                Console.WriteLine("HireDate:    {0}", person.HireDate);
                Console.WriteLine("Discriminator:   {0}", person.Discriminator);
            }
            
            return result.Count;
            
            /*This code produces the following output:
            
                PersonID:    3008
                FirstName:   Vico
                LastName:    Vico
                HireDate:
                Discriminator:   Student
            */
        }
    }
}

Example Refer To

Model Class: Person

Applies to

.NET Standard

2.x