Dynamic Query

This library is for generating Sql Server or Oracle queries using Expressions in strong named format. For creating Sql server or Oracle queries you do not need to change any of your expressions but only QueryEvaluator type.

Installation:

Install the nuget package

Simpe Select:

  var builder = SelectQueryBuilder
                .Initialize()
                .From<TestEntity>();
  
  var SqlSimpleSelect = new SqlServerSelectQueryEvaluator(builder.Query);
  var SqlSimpleSelectQuery = SqlSimpleSelect.toString();
  
  var OracleSimpleSelect = new OracleSelectQueryEvaluator(builder.Query);
  var OracleSimpleSelectQuery = OracleSimpleSelect.toString();

Select with Where

  var builder = SelectQueryBuilder
                .Initialize()
                .From<TestEntity>()
                .Where(n => n.Name.Contains("Yes"));

Result:

SELECT * FROM [TestEntity] WHERE [TestEntity].[Name] LIKE N'%Yes%'

Simple Join:

  var builder = SelectQueryBuilder
                .Initialize()
                .From<StudentEntity>()
                .InnerJoin(s => s.TestEntitytID, (TestEntity t) => t.ID)
                .Select((s, t) => new { s.ID, t.Name });

Result:

SELECT [StudentEntity].[ID], [TestEntity].[Name] FROM [StudentEntity] INNER JOIN [TestEntity] ON [StudentEntity].[TestEntitytID] = [TestEntity].[ID]

Simple Delete

  var builder = DeleteQueryBuilder<StudentEntity>
                .Initialize()
                .Where(s => s.ID == 1);

            var res = new SqlServerDeleteQueryEvaluator(builder.Query);

Result:

DELETE FROM [StudentEntity] WHERE [StudentEntity].[ID] = 1

Simple Update

  var builder = UpdateQueryBuilder<TestEntity>
                .Initialize()
                .Set(s => new TestEntity { Name = "test" })
                .Where(s => s.ID == 1);

            var res = new SqlServerUpdateQueryEvaluator(builder.Query);

Result:

UPDATE ["TestEntity"] SET [Name] = N'test' WHERE [TestEntity].[ID] = 1