Devart Forums

Code: Select all

"TREE_LEVEL"      NUMBER(10,0) DEFAULT 1

Code: Select all

                using (Entities ent = new Entities())
                {
                    String sql = string.Format(@"SELECT * FROM tm_fnet");

                    var results = ent.CreateQuery(sql);

                    foreach (var row in results)
                    {
                        RTTrace.WriteLine(this.TraceName, "id " + row.ID.ToString());
                    }
                }

Code: Select all

            Dictionary> Lookup = new Dictionary>();
            Lookup.Add(200, new List() { 0, 1, 2 });
            Lookup.Add(330, new List() { 0, 1, 4 });

            using (Entities ent = new Entities())
            {
                IQueryable query = null;
                foreach (var x in Lookup)
                {
                    var queryPart = from t in ent.TM_FNET
                                    where t.ACTION.Value == x.Key
                                    && x.Value.Contains(t.STATUS.Value)
                                    select t.ID;

                    //first one becomes the main query, subsequent ones union-ed on...
                    if (query == null)
                        query = queryPart;
                    else
                        query = query.Union(queryPart);
                }

                foreach (var f in query.ToList())
                {
                    Console.WriteLine("{0}", f);
                }
            }

Code: Select all

SELECT 
"Distinct1".C1 AS C1
FROM ( SELECT DISTINCT 
	"UnionAll1".ID AS C1
	FROM  (SELECT 
		"Extent1".ID AS ID
		FROM TMDDBA.TM_FNET "Extent1"
		WHERE ("Extent1".ACTION = :p__linq__0) AND (((0 = "Extent1".STATUS) OR (1 = "Extent1".STATUS)) OR (4 = "Extent1".STATUS))
	UNION ALL
		SELECT 
		"Extent2".ID AS ID
		FROM TMDDBA.TM_FNET "Extent2"
		WHERE ("Extent2".ACTION = :p__linq__1) AND (((0 = "Extent2".STATUS) OR (1 = "Extent2".STATUS)) OR (4 = "Extent2".STATUS))) "UnionAll1"
)  "Distinct1"

Code: Select all

            Dictionary> Lookup = new Dictionary>();

            //Used in my commented out Linq Query
            List Status = new List() { 0, 1, 2, 4 };

            Lookup.Add(200, new List() { 0, 1, 2 });
            Lookup.Add(330, new List() { 0, 1, 4 });

            using (Entities ent = new Entities())
            {

                try
                {
                    //var result = from d in ent.TM_FNET
                    //             where Lookup.Keys.Contains(d.ACTION.Value)
                    //             && Status.Contains(d.STATUS.Value)
                    //             select d;

                    var result = from d in ent.TM_FNET
                                 where Lookup.Keys.Contains(d.ACTION.Value)
                                 && Lookup[d.ACTION.Value].Contains(d.STATUS.Value)
                                 select d;

                    foreach (var f in result)
                    {
                        Console.WriteLine("{0} -- {1} -- {2}", f.ACTION, f.ID, f.STATUS);
                    }

                    Console.WriteLine("Finished");
                    Console.ReadKey();
                }
                catch
                {

                }
            }

Code: Select all

SELECT
        *
FROM
        tm_fnet
WHERE
        (ACTION = 200 AND STATUS IN (0,1,2))
        OR
        (ACTION = 330 AND STATUS IN (0,1,4));

Code: Select all

        public static void SaveFlashnetChanges(EntityKey ek, EntityObject FlashNetObject)
        {
            mtx1.WaitOne();
            using (Entities ent = new Entities(EntitySharedConnection.SharedConnection))
            {
                object FNET_ORIG = null;
                try
                {
                    if (ent.TryGetObjectByKey(ek, out FNET_ORIG))
                    {
                        ent.ApplyPropertyChanges(ek.EntitySetName, FlashNetObject);
                    }
                    ent.SaveChanges();
                }
                catch (Exception ex)
                {
                    Console.WriteLine(ex.Message);
                }
            }
            mtx1.ReleaseMutex();
        }

Code: Select all

Unhandled Exception: System.Data.EntityException: An error occurred while starting a transaction on the provider connection. See the inner exception for details. ---> Devart.Data.Oracle.OracleException: ORA-01453: SET TRANSACTION must be first statement of transaction
   at Devart.Data.Oracle.al.b(Int32 A_0)
   at Devart.Data.Oracle.an.e(Int32 A_0)
   at Devart.Data.Oracle.an.a(Int32 A_0, a1 A_1)
   at Devart.Data.Oracle.OracleCommand.a(CommandBehavior A_0, IDisposable A_1, Int32 A_2, Int32 A_3)
   at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.ExecuteReader()
   at Devart.Data.Oracle.OracleCommand.ExecuteNonQuery()
   at Devart.Data.Oracle.OracleTransaction..ctor(OracleConnection A_0, IsolationLevel A_1)
   at Devart.Data.Oracle.OracleConnection.BeginTransaction(IsolationLevel il)
   at Devart.Data.Oracle.OracleConnection.b(IsolationLevel A_0)
   at System.Data.Common.DbConnection.BeginTransaction(IsolationLevel isolationLevel)
   at System.Data.EntityClient.EntityConnection.BeginDbTransaction(IsolationLevel isolationLevel)
   --- End of inner exception stack trace ---
   at System.Data.EntityClient.EntityConnection.BeginDbTransaction(IsolationLevel isolationLevel)
   at System.Data.Common.DbConnection.BeginTransaction()
   at System.Data.EntityClient.EntityConnection.BeginTransaction()
   at System.Data.Objects.ObjectContext.SaveChanges(Boolean acceptChangesDuringSave)
   at System.Data.Objects.ObjectContext.SaveChanges()
   at ConsoleApplication1.Program.SubmitNewTasks() in C:\Projects\ConsoleApplication1.EntityData\ConsoleApplication1\Program.cs:line 41
   at ConsoleApplication1.Program.Main(String[] args) in C:\Projects\ConsoleApplication1.EntityData\ConsoleApplication1\Program.cs:line 21