Devart Forums

Code: Select all

protected void Page_Load(object sender, EventArgs e)
{
    var resp = this.Response;
    var msgCallback = new Action<object, OracleQueueMessageEventArgs>((ss, ee) =>
    {
        // How to pass "Hello" to client side?
    	resp.Write("Hello");    	
    });
    var orc = new OracleQueueMessageEventHandler(msgCallback);

    // follow the example https://www.devart.com/dotconnect/oracle/docs/aq.html        
    
    OracleQueue oracleDequeueBob = new OracleQueue("MESSAGE_QUEUE", Entry.Connection);
    oracleDequeueBob.DequeueOptions.Navigation = OracleQueueNavigation.FirstMessage;
    oracleDequeueBob.DequeueOptions.ConsumerName = UserName;
    oracleDequeueBob.AsyncNotification = true;
    oracleDequeueBob.OnMessage += orc;          
}

[WebMethod]
public static void UpdateChat(string text)
{
    var oracleEnqueueQueue = new OracleQueue("MESSAGE_QUEUE", Entry.Connection);
    OracleQueueMessage message2 = new OracleQueueMessage();
    message2.StringPayload = text;
    oracleEnqueueQueue.Enqueue(message2);
}      ​

Code: Select all

member procedure set_item(pitem t_variant_named) is
    xindex integer;
  begin
    check_items;
    xindex := index_of(pitem.name);
    if xindex = -1 then
      items.extend;
      items(items.last) := pitem;
    else
      items(xindex) := pitem;
    end if;
  end;

Code: Select all

        public void SetItem(TVariantNamed tVariantNamed)
        {        
            
            OracleParameterCollection xparams = new OracleParameterCollection()
            {
                new OracleParameter("pItem", OracleDbType.Object, tVariantNamed.OracleObject, ParameterDirection.Input)
            };
            var res = OracleObject.ExecuteMethod(_connection, "SET_ITEM", xparams);
            this.OracleObject = xparams["self"].Value as OracleObject;
        }
 

Code: Select all

public void SetItem(TVariantNamed tVariantNamed)
{
      OracleParameterCollection xparams = new OracleParameterCollection()
      {
            new OracleParameter("pItem", OracleDbType.Object, tVariantNamed.OracleObject, ParameterDirection.Input),
      };
      OracleObject.ExecuteMethod(_connection, "SET_ITEM", xparams);
       if (xparams.Contains("self") && xparams["self"].Value as OracleObject != null)
                this.OracleObject = xparams["self"].Value as OracleObject;
}

Code: Select all

public void SetItem(TVariantNamed tVariantNamed)
{
      OracleParameterCollection xparams = new OracleParameterCollection()
      {
            new OracleParameter("pItem", OracleDbType.Object, tVariantNamed.OracleObject, ParameterDirection.Input),
      };
      OracleObject.ExecuteMethod(_connection, "SET_ITEM", xparams);       
}

Code: Select all

 public static IQueryable Query(DataContext context, Type type, string sql)
 {
            var method = context?.GetType()?.GetMethods()?.FirstOrDefault(m => m.Name == "Query" && m.IsGenericMethod);
            if (method == null) return null;
           return method.MakeGenericMethod(type)?.Invoke(context, new[] {sql, (object) null }) as IQueryable;
 }

Code: Select all

public class TestName 
{
   public string name {get; set;}
   public int id {get;set;}
}

Code: Select all

var query = db.Query<TestName>("select name, id from test")

Code: Select all

var query = db.Query<object>("select name, id from test")

Code: Select all

[Table(Name = "TABLE1")]
    public class TdfBlock
    {
        long _No;
        //[Column(Name = "NO", Storage = "_No", IsPrimaryKey = true)]
        [Column(Name = "NO", Storage = "_No")]
        public long No { get { return _No; } }

        string _Rowid;
        [Column(Name = "ROWID", Storage = "_Rowid", IsPrimaryKey = true)]
        public string Rowid { get { return _Rowid; } }
        

        EntitySet<TypeTreeMapping.BaseClasses.Kernel.T51.TdfField> _ES_TdfFields_BlockNo = new EntitySet<TypeTreeMapping.BaseClasses.Kernel.T51.TdfField>();       
        [Association(OtherKey = "BlockNo", Storage = "_ES_TdfFields_BlockNo")]
        public EntitySet<TypeTreeMapping.BaseClasses.Kernel.T51.TdfField> ES_TdfFields_BlockNo { get { return _ES_TdfFields_BlockNo; } }
    }

Code: Select all

 [Table(Name = "TABLE2")]
    public class TdfField
    {
        //long _No;
        ////[Column(Name = "NO", Storage = "_No"]
        //[Column(Name = "NO", Storage = "_No", IsPrimaryKey = true)]
        //public long No { get { return _No; } }

        string _Rowid;
        [Column(Name = "ROWID", Storage = "_Rowid", IsPrimaryKey = true)]
        public string Rowid { get { return _Rowid; } }

        long? _BlockNo;
        ///<summary>Номер блока, в котором содержится поле</summary>
        [Column(Name = "BLOCK_NO", Storage = "_BlockNo")]
        public long? BlockNo { get { return _BlockNo; } }

        
        EntityRef<TypeTreeMapping.BaseClasses.Kernel.T50.TdfBlock> _ER_BlockNo_50;       
        [Association(ThisKey = "BlockNo", Storage = "_ER_BlockNo_50")]
        public TypeTreeMapping.BaseClasses.Kernel.T50.TdfBlock E_BlockNo_50
        {
            get
            {                
                return _ER_BlockNo_50.Entity;
            }
        }
    }