protected QuerySyntaxHelper(ITypeTranslater translater, IAggregateHelper aggregateHelper, IUpdateHelper updateHelper, DatabaseType databaseType)
{
TypeTranslater = translater;
AggregateHelper = aggregateHelper;
UpdateHelper = updateHelper;
DatabaseType = databaseType;
}
public string TranslateSQLDBType(string sqlType, ITypeTranslater destinationTypeTranslater)
{
//e.g. data_type is datetime2 (i.e. Sql Server), this returns System.DateTime
DatabaseTypeRequest requested = GetDataTypeRequestForSQLDBType(sqlType);
//this then returns datetime (e.g. mysql)
return(destinationTypeTranslater.GetSQLDBTypeForCSharpType(requested));
}
/// <summary>
/// Returns the DBMS specific datatype for storing a dicom tag of the supplied <paramref name="keyword"/> (must be a dicom tag name).
/// </summary>
/// <param name="keyword"></param>
/// <param name="tt"></param>
/// <returns></returns>
public static string GetDataTypeForTag(string keyword, ITypeTranslater tt)
{
var tag = DicomDictionary.Default.FirstOrDefault(t => t.Keyword == keyword);
if (tag == null)
{
throw new NotSupportedException("Keyword '" + keyword + "' is not a valid Dicom Tag.");
}
var type = DicomTypeTranslater.GetNaturalTypeForVr(tag.ValueRepresentations, tag.ValueMultiplicity);
return(tt.GetSQLDBTypeForCSharpType(type));
}
/// <summary>
/// Returns <see cref="ExplicitDbType"/> if set or uses the <see cref="TypeTranslater"/> to generate a proprietary type name for <see cref="TypeRequested"/>
/// </summary>
/// <param name="typeTranslater"></param>
/// <returns></returns>
public string GetSQLDbType(ITypeTranslater typeTranslater)
{
return(ExplicitDbType ?? typeTranslater.GetSQLDBTypeForCSharpType(TypeRequested));
}
public string GetSqlDBType(ITypeTranslater translater)
{
return(translater.GetSQLDBTypeForCSharpType(GetTypeRequest()));
}
public static string GetSqlDBType(this Guesser guesser, ITypeTranslater tt)
{
return(tt.GetSQLDBTypeForCSharpType(guesser.Guess));
}
