Show / Hide Table of Contents

    IQueryWhereBuilder.WhereRaw(string whereClause, params ISqlParameter[] parameters) Method

    .NET Standard 2.x

    Creates a WHERE clause, and adds a raw SQL to the WHERE clause.

    Namespace: SnapObjects.Data

    Assembly: SnapObjects.Data.dll

    Syntax

      IQueryAndOrBuilder<TModel> WhereRaw(string whereClause, params ISqlParameter[] parameters);
    

    Parameters

    whereClause System.String

    A string of raw SQL to be added to the WHERE clause.

    parameters SnapObjects.Data.ISqlParameter[]

    (Optional) An array of ISqlParameter objects which defines the SQL parameters used in the raw SQL.

    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 WhereRaw method to build the WHERE condition in a raw SQL.

    using Appeon.ApiDoc.Models.School;
    using SnapObjects.Data;
    using System;
    using System.Threading.Tasks;
    
    namespace Appeon.ApiDoc.IQueryWhereBuilderExamples
    {
        public class WhereRawExample
        {
            private SchoolContext _context;
            
            public WhereRawExample(SchoolContext dataContext)
            {
                // Sets Data Context
                _context = dataContext;
            }
    
            public async Task<int> Example()
            {
                // Get a QueryBuilder.
                var Builder = _context.SqlModelMapper.GetQueryBuilder<Department>();
                
                // Creates a WHERE clause, and adds a raw SQL to the WHERE clause.
                Builder.WhereRaw("DepartmentID = :id", SqlBuilder.Parameter<int>("id"));
                
                var result = (await Builder.LoadAsync(4)).FirstOrDefault();
                
                Console.WriteLine("DepartmentID:    {0}", result.DepartmentID);
                Console.WriteLine("Name:            {0}", result.Name);
                Console.WriteLine("Budget:          {0}", result.Budget);
                Console.WriteLine("Administrator:   {0}", result.Administrator);
                Console.WriteLine("StartDate:       {0}", result.StartDate);
                
                return result.DepartmentID;
                
                
                /*This code example produces the following output:   
                
                    DepartmentID:    4
                    Name:            Economics
                    Budget:          200000.0000
                    Administrator:   4
                    StartDate:       9/1/2007 12:00:00 AM
                */
            }
        }
    }
    

    Example Refer To

    Model Class: Department

    Applies to

    .NET Standard

    2.x

    Back to top Generated by Appeon