public override void MountQuery(IDataShape model)
{
string query = String.Format("DELETE FROM [{0}] WHERE {1}",
model.GetType().Name,
String.Join(", ", this._list.ToArray()));
this._command = this._dbDao.GetSqlCommand(query);
}
public override void MountQuery(IDataShape model)
{
string query = String.Format("UPDATE [{0}] SET {1} WHERE [Id] = @Id",
model.GetType().Name,
String.Join(", ", this._list.ToArray()));
this._command = this._dbDao.GetSqlCommand(query);
}
public override void MountQuery(IDataShape model)
{
string query = String.Format("DELETE FROM [{0}] WHERE {1}",
model.GetType().Name,
String.Join(", ", this._list.ToArray()));
this._command = this._dbDao.GetSqlCommand(query);
}
public override void MountQuery(IDataShape model)
{
string query = String.Format("UPDATE [{0}] SET {1} WHERE [Id] = @Id",
model.GetType().Name,
String.Join(", ", this._list.ToArray()));
this._command = this._dbDao.GetSqlCommand(query);
}
public override void MountQuery(IDataShape model)
{
string query = String.Format("INSERT INTO [{0}] ( {1} ) VALUES ( {2} )",
model.GetType().Name,
String.Join(", ", this._dictionary.Keys),
String.Join(", ", this._dictionary.Values));
this._command = this._dbDao.GetSqlCommand(query);
}
public override void MountQuery(IDataShape model)
{
string query = String.Format("INSERT INTO [{0}] ( {1} ) VALUES ( {2} )",
model.GetType().Name,
String.Join(", ", this._dictionary.Keys),
String.Join(", ", this._dictionary.Values));
this._command = this._dbDao.GetSqlCommand(query);
}
public override void MountQuery(IDataShape model)
{
string query = String.Format("SELECT * FROM [{0}] {1} {2}",
model.GetType().Name,
this._list.ToArray().Length > 0 ? "WHERE" : "",
String.Join(" AND ", this._list.ToArray()));
this._command = this._dbDao.GetSqlCommand(query);
}
