public override string ResolveTableName(TypeInfo ti)
{
if (!string.IsNullOrEmpty(ti.Schema))
return string.Concat(ti.Schema, ".", ti.TableName);
else
return ti.TableName;
}
public override string ResolveTableName(TypeInfo ti, bool EscapeTableName)
{
return ResolveTableName(ti);
}
/// <summary>
/// Resolves the name of the table.
/// </summary>
/// <param name="ti">The ti.</param>
/// <param name="EscapeTableName">Should the table name be escaped</param>
/// <returns></returns>
public virtual string ResolveTableName(TypeInfo ti, bool EscapeTableName)
{
string toReturn = EscapeTableName ? ti.TableName : ti.UnescapedTableName;
if (!string.IsNullOrEmpty(ti.Schema))
toReturn = string.Format("{0}{1}_{2}{3}", EscapeTableName ? DataManager.Connection.LeftEscapeCharacter : "", ti.UnEscapedSchema, ti.UnescapedTableName
, EscapeTableName ? DataManager.Connection.RightEscapeCharacter : "");
return toReturn;
}
/// <summary>
/// Gets the object parameters.
/// </summary>
/// <param name="startingIndex">The number of parameters you already have.</param>
/// <param name="item">The item.</param>
/// <param name="TypeInfo">The type info.</param>
/// <returns></returns>
protected List<ParameterData> GetObjectParameters(int startingIndex, object item, TypeInfo TypeInfo)
{
List<ParameterData> toReturn = new List<ParameterData>();
foreach (DataFieldInfo info in TypeInfo.DataFields)
{
if (info.SetOnInsert)
{
object value;
if (info.SetNull)
{
value = null;
}
else
{
value = info.Getter(item, null);
}
if (value != null)
value = DataManager.Connection.TypeConverter.ConvertToType(value, info.PropertyType);
IDbDataParameter parm = DataManager.Connection.GetParameter(startingIndex.ToString(), value);
startingIndex++;
toReturn.Add(new ParameterData(parm, info.EscapedFieldName));
}
}
return toReturn;
}
/// <summary>
/// Resolves the name of the table.
/// </summary>
/// <param name="ti">The ti.</param>
/// <returns></returns>
public virtual string ResolveTableName(TypeInfo ti)
{
return ResolveTableName(ti, true);
}