public OdbcCommandBuilder()
{
_adapter = null;
_quotePrefix = String.Empty;
_quoteSuffix = String.Empty;
rowUpdatingHandler = null;
}
/// <summary>
/// Extends BeginInvoke so that when a state object is not needed, null does not need to be passed.
/// <example>
/// odbcrowupdatingeventhandler.BeginInvoke(sender, e, callback);
/// </example>
/// </summary>
public static IAsyncResult BeginInvoke(this OdbcRowUpdatingEventHandler odbcrowupdatingeventhandler, Object sender, OdbcRowUpdatingEventArgs e, AsyncCallback callback)
{
if (odbcrowupdatingeventhandler == null)
{
throw new ArgumentNullException("odbcrowupdatingeventhandler");
}
return(odbcrowupdatingeventhandler.BeginInvoke(sender, e, callback, null));
}
/// <include file='doc\OdbcDataAdapter.uex' path='docs/doc[@for="OdbcDataAdapter.OnRowUpdating"]/*' />
override protected void OnRowUpdating(RowUpdatingEventArgs value)
{
OdbcRowUpdatingEventHandler handler = (OdbcRowUpdatingEventHandler)Events[EventRowUpdating];
if ((null != handler) && (value is OdbcRowUpdatingEventArgs))
{
handler(this, (OdbcRowUpdatingEventArgs)value);
}
}
protected override void OnRowUpdating(RowUpdatingEventArgs value)
{
OdbcRowUpdatingEventHandler handler = (OdbcRowUpdatingEventHandler)base.Events[EventRowUpdating];
if ((handler != null) && (value is OdbcRowUpdatingEventArgs))
{
handler(this, (OdbcRowUpdatingEventArgs)value);
}
base.OnRowUpdating(value);
}
// FIXME: According to MSDN - "if this method is called again with
// the same DbDataAdapter, the DbCommandBuilder is unregistered for
// that DbDataAdapter's RowUpdating event" - this behaviour is yet
// to be verified
protected override void SetRowUpdatingHandler(DbDataAdapter adapter)
{
if (!(adapter is OdbcDataAdapter))
{
throw new InvalidOperationException("Adapter needs to be a SqlDataAdapter");
}
if (rowUpdatingHandler == null)
{
rowUpdatingHandler = new OdbcRowUpdatingEventHandler(OnRowUpdating);
}
((OdbcDataAdapter)adapter).RowUpdating += rowUpdatingHandler;
}
private void ClearHandlers()
{
if (null != this.adohandler)
{
((OleDbDataAdapter)this.adapter).RowUpdating -= this.adohandler;
this.adohandler = null;
}
else if (null != this.sqlhandler)
{
((SqlDataAdapter)this.adapter).RowUpdating -= this.sqlhandler;
this.sqlhandler = null;
}
else if (null != this.odbchandler)
{
((OdbcDataAdapter)this.adapter).RowUpdating -= this.odbchandler;
this.odbchandler = null;
}
}
// FIXME: According to MSDN - "if this method is called again with
// the same DbDataAdapter, the DbCommandBuilder is unregistered for
// that DbDataAdapter's RowUpdating event" - this behaviour is yet
// to be verified
protected override void SetRowUpdatingHandler (DbDataAdapter adapter)
{
if (!(adapter is OdbcDataAdapter))
throw new InvalidOperationException ("Adapter needs to be a SqlDataAdapter");
if (rowUpdatingHandler == null)
rowUpdatingHandler = new OdbcRowUpdatingEventHandler (OnRowUpdating);
((OdbcDataAdapter) adapter).RowUpdating += rowUpdatingHandler;
}
