Discussion forums for open issues and questions concerning database tools, data access components and developer tools from Devart
https://forums.devart.com/
Code: Select all
(MyObjectContext.Connection as System.Data.EntityClient.EntityConnection).StoreConnectionCode: Select all
(((IObjectContextAdapter)MyDbContext).ObjectContext.Connection as System.Data.EntityClient.EntityConnection).StoreConnectionThis functionality will not help to execute a script which consists of several commands.Dennis Wanke wrote:it would suffice just to trim whitespaces and known statement delimiters at the end of the script, e.g. by calling CommandText.TrimEnd(' ', '\t', '\r', '\n', ';', '/')
Code: Select all
SELECT (
SELECT t6.AMT
FROM (
SELECT t7.DES, t7.AMT, t7.EFF_DT
FROM DABC_TAB.TAX_RATE t7
WHERE t7.TAX_TYPE = :p0
) t6
WHERE (t1.DES = t6.DES) AND (ROWNUM <= 1)
) AS AMT
FROM (
SELECT t2.DES
FROM (
SELECT t3.DES
FROM DABC_TAB.TAX_RATE t3
WHERE t3.TAX_TYPE = :p0
ORDER BY t3.EFF_DT DESC
) t2
GROUP BY t2.DES
) t1
WHERE (ROWNUM <= 1) AND (((
SELECT t4.DES
FROM (
SELECT t5.DES, t5.EFF_DT
FROM DABC_TAB.TAX_RATE t5
WHERE t5.TAX_TYPE = :p0
) t4
WHERE (t1.DES = t4.DES) AND (ROWNUM <= 1)
)) = :p1)Code: Select all
ALTER TABLE MYTAX.TAX_RATE
DROP PRIMARY KEY CASCADE;
DROP TABLE MYTAX.TAX_RATE CASCADE CONSTRAINTS;
CREATE TABLE MYTAX.TAX_RATE
(
TAX_TYPE VARCHAR2(2 BYTE),
DES VARCHAR2(40 BYTE),
AMT NUMBER(6,4),
EFF_DT DATE,
CREATE_USER VARCHAR2(8 BYTE),
CREATE_DATE DATE
)
TABLESPACE TABLES
PCTUSED 0
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 40K
NEXT 1M
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT
)
LOGGING
NOCOMPRESS
NOCACHE
NOPARALLEL
NOMONITORING;
CREATE UNIQUE INDEX MYTAX.TAX_RATE_PK ON MYTAX.TAX_RATE
(CREATE_DATE, EFF_DT, AMT, DES, TAX_TYPE)
LOGGING
TABLESPACE TABLES
PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE (
INITIAL 1M
NEXT 1M
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT
)
NOPARALLEL;
ALTER TABLE MYTAX.TAX_RATE ADD (
CONSTRAINT TAX_RATE_PK
PRIMARY KEY
(CREATE_DATE, EFF_DT, AMT, DES, TAX_TYPE)
USING INDEX MYTAX.TAX_RATE_PK
ENABLE VALIDATE);Code: Select all
TAX_TYPE DES AMT EFF_DT CREATE_USER CREATE_DATE
CI PARK CITY 1.9 4/1/2013 NULL 4/1/2013
CO BOX ELDER 0.25 7/1/1999 NULL 7/1/1999
CI PRICE 0.25 7/1/1999 NULL 7/1/1999
CI GARFIELD 1.25 4/1/2000 NULL 4/1/2000Code: Select all
/// <summary>
/// There are no comments for DotNetContext.TAXRATE in the schema.
/// </summary>
[Table(Name = @"TAX_RATE")]
public partial class TAXRATE : INotifyPropertyChanging, INotifyPropertyChanged
{
private static PropertyChangingEventArgs emptyChangingEventArgs = new PropertyChangingEventArgs(System.String.Empty);
private string _TAXTYPE;
private string _DES;
private double _AMT;
private System.DateTime _EFFDT;
private string _CREATEUSER;
private System.DateTime _CREATEDATE;
#region Extensibility Method Definitions
partial void OnLoaded();
partial void OnValidate(System.Data.Linq.ChangeAction action);
partial void OnCreated();
partial void OnTAXTYPEChanging(string value);
partial void OnTAXTYPEChanged();
partial void OnDESChanging(string value);
partial void OnDESChanged();
partial void OnAMTChanging(double value);
partial void OnAMTChanged();
partial void OnEFFDTChanging(System.DateTime value);
partial void OnEFFDTChanged();
partial void OnCREATEUSERChanging(string value);
partial void OnCREATEUSERChanged();
partial void OnCREATEDATEChanging(System.DateTime value);
partial void OnCREATEDATEChanged();
#endregion
public TAXRATE()
{
OnCreated();
}
/// <summary>
/// There are no comments for TAXTYPE in the schema.
/// </summary>
[Column(Name = @"TAX_TYPE", Storage = "_TAXTYPE", CanBeNull = false, DbType = "VARCHAR2(2 CHAR) NOT NULL", IsPrimaryKey = true)]
public string TAXTYPE
{
get
{
return this._TAXTYPE;
}
set
{
if (this._TAXTYPE != value)
{
this.OnTAXTYPEChanging(value);
this.SendPropertyChanging();
this._TAXTYPE = value;
this.SendPropertyChanged("TAXTYPE");
this.OnTAXTYPEChanged();
}
}
}
/// <summary>
/// There are no comments for DES in the schema.
/// </summary>
[Column(Storage = "_DES", CanBeNull = false, DbType = "VARCHAR2(40 CHAR) NOT NULL", IsPrimaryKey = true)]
public string DES
{
get
{
return this._DES;
}
set
{
if (this._DES != value)
{
this.OnDESChanging(value);
this.SendPropertyChanging();
this._DES = value;
this.SendPropertyChanged("DES");
this.OnDESChanged();
}
}
}
/// <summary>
/// There are no comments for AMT in the schema.
/// </summary>
[Column(Storage = "_AMT", CanBeNull = false, DbType = "NUMBER(6,4) NOT NULL", IsPrimaryKey = true)]
public double AMT
{
get
{
return this._AMT;
}
set
{
if (this._AMT != value)
{
this.OnAMTChanging(value);
this.SendPropertyChanging();
this._AMT = value;
this.SendPropertyChanged("AMT");
this.OnAMTChanged();
}
}
}
/// <summary>
/// There are no comments for EFFDT in the schema.
/// </summary>
[Column(Name = @"EFF_DT", Storage = "_EFFDT", CanBeNull = false, DbType = "DATE NOT NULL", IsPrimaryKey = true)]
public System.DateTime EFFDT
{
get
{
return this._EFFDT;
}
set
{
if (this._EFFDT != value)
{
this.OnEFFDTChanging(value);
this.SendPropertyChanging();
this._EFFDT = value;
this.SendPropertyChanged("EFFDT");
this.OnEFFDTChanged();
}
}
}
/// <summary>
/// There are no comments for CREATEUSER in the schema.
/// </summary>
[Column(Name = @"CREATE_USER", Storage = "_CREATEUSER", DbType = "VARCHAR2(8 CHAR) NULL")]
public string CREATEUSER
{
get
{
return this._CREATEUSER;
}
set
{
if (this._CREATEUSER != value)
{
this.OnCREATEUSERChanging(value);
this.SendPropertyChanging();
this._CREATEUSER = value;
this.SendPropertyChanged("CREATEUSER");
this.OnCREATEUSERChanged();
}
}
}
/// <summary>
/// There are no comments for CREATEDATE in the schema.
/// </summary>
[Column(Name = @"CREATE_DATE", Storage = "_CREATEDATE", CanBeNull = false, DbType = "DATE NOT NULL", IsPrimaryKey = true)]
public System.DateTime CREATEDATE
{
get
{
return this._CREATEDATE;
}
set
{
if (this._CREATEDATE != value)
{
this.OnCREATEDATEChanging(value);
this.SendPropertyChanging();
this._CREATEDATE = value;
this.SendPropertyChanged("CREATEDATE");
this.OnCREATEDATEChanged();
}
}
}