Devart Forums

Code: Select all

public class Table1
	{
		#region Constructors and Destructors

		public Table1()
		{
			this.Table2 = new WcfObservableCollection<Table2>();
			this.Table3 = new WcfObservableCollection<Table3>();
		}

		#endregion

		#region Properties

		public bool PropertyBool { get; set; }

		[NotNullValidator]
		public string PropertyText { get; set; }

		public string PropertyTextNullable { get; set; }
		public WcfObservableCollection<Table2> Table2 { get; set; }
		public WcfObservableCollection<Table3> Table3 { get; set; }

		#endregion
	}

Code: Select all

public class TABLE1Map : EntityTypeConfiguration<Table1>
    {
        public TABLE1Map()
        {

            // Primary Key
            this.HasKey(t => t.Id);

            // Properties
            this.Property(t => t.Id)
                .HasDatabaseGeneratedOption(DatabaseGeneratedOption.Identity);

            this.Property(t => t.PropertyText)
                .IsRequired()
                .HasMaxLength(50);

            this.Property(t => t.PropertyTextNullable)
                .HasMaxLength(50);

            // Table & Column Mappings
            this.ToTable("TABLE1", "DEV_KOTVA");
            this.MapToStoredProcedures(s=>s.Insert(i=>i.HasName("TABLE1_INSERT", "KOTVA_ADAPTER")).Update(d=>d.HasName("TABLE1_UPDATE", "KOTVA_ADAPTER")).Delete(d=>d.HasName("TABLE1_DELETE", "KOTVA_ADAPTER")));
            this.Property(t => t.Id).HasColumnName("TABLE1_ID");
            this.Property(t => t.PropertyText).IsUnicode(false).HasColumnName("PROPERTYTEXT");
            this.Property(t => t.PropertyBool).HasColumnName("PROPERTYBOOL");
			this.Property(t => t.PropertyTextNullable).IsUnicode(false).HasColumnName("PROPERTYTEXTNULLABLE");

            // Relationships
            this.HasMany(t => t.Table3)
                .WithMany(t => t.Table1)
                .Map(m => 
					{
						m.ToTable("TABLE12TABLE3");
						m.MapLeftKey("TABLE1_ID");
						m.MapRightKey("TABLE3_ID"); 
					})
                .MapToStoredProcedures(s=>s.Insert(i=>i.HasName("TABLE12TABLE3_INSERT", "KOTVA_ADAPTER")).Delete(d=>d.HasName("TABLE12TABLE3_DELETE", "KOTVA_ADAPTER")));


        }
    }

Code: Select all

PROCEDURE Table1_Update
  (
    TABLE1_ID            IN NUMBER,
    PROPERTYTEXT         IN VARCHAR2,
    PROPERTYBOOL         IN NUMBER,
    PROPERTYTEXTNULLABLE IN VARCHAR2
  ) IS
  BEGIN
  
    UPDATE Table1 t
    SET    t.PROPERTYTEXT         = Table1_Update.PROPERTYTEXT,
           t.PROPERTYBOOL         = Table1_Update.PROPERTYBOOL,
           t.PROPERTYTEXTNULLABLE = Table1_Update.PROPERTYTEXTNULLABLE
    WHERE  t.TABLE1_ID = Table1_Update.TABLE1_ID;
  
  END Table1_Update;

PROCEDURE Table1_Insert
  (
    PROPERTYTEXT         IN VARCHAR2,
    PROPERTYBOOL         IN NUMBER,
    PROPERTYTEXTNULLABLE IN VARCHAR2,
    currParam            OUT SYS_REFCURSOR
  ) IS
    TABLE1_ID NUMBER := SQ_TABLE1.nextval;
  BEGIN
  
    INSERT INTO TABLE1 t
      (t.TABLE1_ID,
       t.PROPERTYTEXT,
       t.PROPERTYBOOL,
       t.PROPERTYTEXTNULLABLE)
    VALUES
      (Table1_Insert.TABLE1_ID,
       Table1_Insert.PROPERTYTEXT,
       Table1_Insert.PROPERTYBOOL,
       Table1_Insert.PROPERTYTEXTNULLABLE);
  
    OPEN currParam FOR
      SELECT Table1_Insert.TABLE1_ID AS TABLE1_ID
      FROM   dual;
  
  END Table1_Insert;

Code: Select all

KOTVA_ADAPTER.TABLE1_INSERT
-- PROPERTYBOOL: 'False' (Type = Boolean, IsNullable = false)
-- PROPERTYTEXT: 'tble1' (Type = String, IsNullable = false, Size = 5)
-- PROPERTYTEXTNULLABLE: 'null' (Type = String, IsNullable = false)
-- Executing at 4.11.2014 10:51:26 +01:00
-- Completed in 99 ms with result: aj

Code: Select all

KOTVA_ADAPTER.TABLE1_UPDATE
-- TABLE1_ID: '40' (Type = Decimal, IsNullable = false)
-- PROPERTYBOOL: 'False' (Type = Boolean, IsNullable = false)
-- PROPERTYTEXT: 'tble1_changed' (Type = String, IsNullable = false, Size = 13)
-- PROPERTYTEXTNULLABLE: 'null' (Type = String, IsNullable = false)
-- Executing at 4.11.2014 10:51:29 +01:00
-- Failed in 140 ms with error: ORA-06502: PL/SQL: numeric or value error: character to number conversion error
ORA-06512: at line 2

Code: Select all

BEGIN KOTVA_ADAPTER.TABLE1_UPDATE(:TABLE1_ID,:PROPERTYBOOL,:PROPERTYTEXT,:PROPERTYTEXTNULLABLE);END;

Code: Select all

public long? Id { get; set; }	
public bool PropertyBool { get; set; }
public string PropertyText { get; set; }
public string PropertyTextNullable { get; set; }

Code: Select all

public long? Id { get; set; }	
public string PropertyText { get; set; }
public bool PropertyBool { get; set; }
public string PropertyTextNullable { get; set; }