Devart Forums

Code: Select all

		public static IQueryable Current(this IQueryable source)
		{
			var entParam = Expression.Parameter(typeof(TSource), "ent");
			var entParam2 = Expression.Parameter(typeof(TSource), "ent");
			return source
				.Where(
					Expression.Lambda>(
						Expression.Equal(Expression.Property(entParam, typeof(TSource).GetProperty("EntityId")), 
                                                       Expression.Constant(0L)), new[] { entParam }))
				.Where(
					Expression.Lambda>(
						Expression.Equal(Expression.Property(entParam2, typeof(TSource).GetProperty("RecordStatus")), 
                                                       Expression.Constant(0L)), new[] { entParam2 }));
		}

Code: Select all

var contacts = from c in DB.Contacts.Current()
               where !(from u in DB.Users
			           select u.ContactId).Contains(c.Id)
               select c.Id;

Code: Select all

var contacts = from c in DB.Contacts.Current()
               where !(from u in DB.Users.Current()
			           select u.ContactId).Contains(c.Id)
               select c.Id;

Code: Select all

var contacts = from c in DB.Contacts.Current()
               where !(from u in DB.Users.Current()
			           select u.ContactId).Contains(c.Id)
               select c.Id;

Code: Select all

var contacts = from c in DB.Contacts.Current()
               where !(from u in DB.Users
                       where u.EntityId == 0 && e.RecordStatus == 0
			           select u.ContactId).Contains(c.Id)
               select c.Id;

Code: Select all

SELECT t1.ID
FROM CONTACT t1
WHERE (NOT (EXISTS
    (
        SELECT t2.CONTACT_ID AS "ContactId"
        FROM USERS t2
        WHERE (t2.CONTACT_ID = t1.ID) AND (t2.ENTITY_ID = :p0) AND (t2.RECORD_STATUS = :p1)
        )
    )) AND (t1.RECORD_STATUS = :p2) AND (t1.ENTITY_ID = :p3)

Code: Select all

var docs = (from d in DB.Documents
            select new { d.Id, Role = d.DocumentName })
    .Concat(from d in DB.Documents
            select new { d.Id, Role = d.DocumentType });

var data = from d in DB.Documents
           join doc in docs on d.Id equals doc.Id
           select new {
               d.Id,
               ContactRole = doc.Role
           };

Code: Select all

SELECT t1.ID AS "Id", t2."DocumentType" AS "Role"      --should be t2."DocumentName" or t2."Role" 
FROM DOCUMENT t1
INNER JOIN (
    (
        SELECT t3.ID AS "Id", t3.DOCUMENT_NAME AS "DocumentName"
        FROM DOCUMENT t3
        )
    UNION ALL
    (
        SELECT t4.ID AS "Id", t4.DOCUMENT_TYPE AS "DocumentType"
        FROM DOCUMENT t4
        )
    ) t2 ON t1.ID = t2."Id"

Code: Select all

Message ORA-00904: "T2"."DocumentType": invalid identifier
  
StackTrace    at xc.u.d()
   at Devart.Data.Oracle.bi.c()
   at Devart.Data.Oracle.q.a(Int32 A_0, a4 A_1)
   at Devart.Data.Oracle.OracleCommand.InternalExecute(CommandBehavior behavior, IDisposable disposable, Int32 startRecord, Int32 maxRecords, Boolean nonQuery)
   at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior, Boolean nonQuery)
   at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()
   at Devart.Data.Linq.Provider.DataProvider.ExecuteQuery(CompiledQuery compiledQuery, Object[] parentArgs, Object[] userArgs, Object lastResult)  

Code: Select all

System.InvalidOperationException: Cannot refresh Entity. Record does not exist.
   at Devart.Data.Linq.Provider.DataProvider.GetAutoSyncValues(MetaType type, IDbCommand dbCommand, IList`1 autoSyncFields, IList`1 autoSyncParameters, IList`1 keyFields, IList`1 keyParameters)
   at Devart.Data.Linq.o.a(a A_0, MetaType A_1, h A_2, ModifiedMemberInfo[] A_3, Boolean A_4)
   at Devart.Data.Linq.l.a(i A_0, z A_1, Object A_2, Boolean A_3)
   at Devart.Data.Linq.u.a(l A_0, z A_1, Boolean A_2)
   at Devart.Data.Linq.u.a(DataContext A_0, ConflictMode A_1)
   at Devart.Data.Linq.DataContext.SubmitChanges(ConflictMode failureMode)

Code: Select all

				DB.LogUsers.InsertOnSubmit(new LogUser {
				        		Action = action,
				        		Ip = ip,
				        		Logtime = DateTime.Now,
				        		Message = message,
				        		Sessionid = sessionID,
				        		Success = success,
				        		UserName = userName
				        	});
				DB.SubmitChanges();

Code: Select all

Code: Select all

   Specified method is not supported.
   at Devart.Data.Linq.Provider.Query.ao.a(SqlNode A_0, f A_1, SqlExpression A_2, Boolean A_3)
   at Devart.Data.Linq.Provider.Query.bf.b.a(w A_0)
   at Devart.Data.Linq.Provider.Query.SqlVisitor.a(f A_0)
   at Devart.Data.Linq.Provider.Query.SqlVisitor.a(d A_0)
   at Devart.Data.Linq.Provider.Query.SqlVisitor.a(j A_0)
   at Devart.Data.Linq.Provider.Query.SqlVisitor.e(w A_0)
   at Devart.Data.Linq.Provider.Query.bf.b.a(w A_0)
   at Devart.Data.Linq.Provider.Query.SqlVisitor.a(f A_0)
   at Devart.Data.Linq.Provider.Query.bf.a(SqlNode A_0, SqlFactory A_1, Boolean& A_2)
   at Devart.Data.Linq.Provider.DataProvider.a(e A_0, Type A_1, SqlNode A_2, IList`1 A_3)
   at Devart.Data.Linq.Provider.DataProvider.a(Expression A_0)
   at Devart.Data.Linq.Provider.DataProvider.i(Expression A_0)
   at Devart.Data.Linq.DataQuery`1.i()

Code: Select all

var DB = new DataContext(ConnectionString);
							
var a = from d in DB.Documents
	    join spd in DB.SitePacketDocuments on d equals spd.Document
	    where spd.Id == 1
	    select new {SiteId = 5, DocId = d.Id};
var b = from d in DB.Documents
	    select new {SiteId = 5, DocId = d.Id};

var u = a.Concat(b);
DB.GetCommand(u).CommandText.Dump(); //Ok here

var sitedocs = (from d in DB.Documents
				join did in u on d.Id equals did.DocId
				select new { did.SiteId, DocumentId = d.Id });
DB.GetCommand(sitedocs).CommandText.Dump(); //Not so ok

Code: Select all

var a = from d in DB.Documents
	    join spd in DB.SitePacketDocuments on d equals spd.Document
	    where d.Id == 1
	    select new {SiteId = 5, DocId = d.Id};

Code: Select all

 public enum RecordStatus
  {
   Active = 0,
   Inactive = 1,
   Deleted = 2
  }