Devart Forums

Code: Select all

User Id=postgres;Password=1;Host=localhost;Database=MyDb;Unicode=True;Persist Security Info=True;Schema=public;Min Pool Size=1;Max Pool Size=100;Connection Lifetime=1600;Pooling=True

Code: Select all

Connect: User Id=postgres;Password=1;Host=localhost;Database=MyDb;Unicode=True;Persist Security Info=True;Schema=public;Min Pool Size=1;Max Pool Size=100;Connection Lifetime=1600;Pooling=True
Disconnect
Connect: ...
Disconnect
Connect: ...
Disconnect

Code: Select all

using(var entities = new DataEntities())
{
    var test = entities.TestItems.Where(o=>o.Name.EndsWith("v")).ToList();
}

Code: Select all

long? condition = null; 
var query = from table in context.Table 
where condition == null ? true : table.Id == condition; 

Code: Select all

long? condition = null; 
var query = from table in context.Table 
where condition == null ? true : table.Id == condition.Value; 

Code: Select all

SELECT t1."Id" FROM public.Table t1
WHERE 
    (CASE 
        WHEN :p0 THEN :p1
        ELSE t1."Id" IS NULL
     END)
-------
p0 = true
p1 = true

Code: Select all

long? condition = 1; 
var query = from table in context.Table 
where condition == null ? true : table.Id == condition.Value; 

Code: Select all

SELECT t1."Id" FROM public.Table t1
WHERE 
    (CASE 
        WHEN :p0 THEN :p1
        ELSE t1."Id" = :p2
     END)
-------
p0 = false
p1 = true
p2 = 1

Code: Select all

long? condition = null;
var query = from table in context.Table 
where table.Id == condition
select table;

Code: Select all

long? condition = null; 
var query = from table in context.Table 
where condition == null ? true : table.Id == condition.Value; 

Code: Select all

long? condition = null; 
long conditionValue = condition == null ? -1 : conditionValue;
var query = from table in context.Table 
where condition == null ? true : table.Id == conditionValue; 

Code: Select all

long? condition = 1;
var query = from table in context.Table
where condition == null ? true : table.Id == condition.Value;

Code: Select all

long? condition = 1;
long conditionValue = condition.Value;
var query = from table in context.Table
where condition == null ? true : table.Id == conditionValue;

Code: Select all

    public interface IIdEntity
    {
        long Id { get; set; }
    }

Code: Select all

    partial class TestDataContext
    {

        // Place your implementation of partial extension methods here
    }

    public partial class ytrewqs: IIdEntity
    {

    }

    public interface IIdEntity
    {
        long Id { get; set; }
    }

Code: Select all

        public void Test()
        {
                var except = new List();
                except.Add(1);
                var result1 = GetData(context, except );
                except.Add(2);
                var result2 = GetData(context, except );
        }

        private IList GetData(TestDataContext context, IEnumerable except)
            where T : class, IIdEntity
        {
            return context.GetTable().Where(o => !except.Contains(o.Id)).ToList();
        }

Code: Select all

bool condition = true;
var query = from table in context.Table
where condition == true ? table.Id == 1 : true
select table;

Code: Select all

var query = from tr in context.Table
where tr.Status == (nullstatus ? null : new int?(-1)) || statuses.Contains(tr.Status) == statusesIn
select tr;

Code: Select all

var query = from tr in context.Table 
where statuses.Contains(tr.Status) == statusesIn 
select tr;

Code: Select all

SELECT *
FROM directive_line t1
WHERE (t1."Id", t1."IdSomeOther") in ((13, 10), (11, 9))

Code: Select all

public class ObjectForQuery
{
    public long Id{get;set;}
    public long IdSomeOther{get;set;}
}

....

var objectsForSearch = new List
{
    new ObjectForQuery{Id = 13, IdSomeOther = 10},
    new ObjectForQuery{Id = 11, IdSomeOther = 9},
};

var list = (from directiveLineDB in context.DirectiveLines
where objectsForSearch.Select(o => new {o.Id, o.IdSomeOther }).Contains(new { Id = directiveLineDB .Id, IdSomeOther= directiveLineDB.IdSomeOther})
select directiveLineDB).ToList();