private tgProviderSpecificMetadata tgDefault(string mapName)
{
if (!m_providerMetadataMaps.ContainsKey(mapName))
{
tgProviderSpecificMetadata meta = new tgProviderSpecificMetadata();
meta.AddTypeMap("Id", new tgTypeMap("integer", "System.Int32"));
meta.AddTypeMap("EmailAddress", new tgTypeMap("varchar", "System.String"));
meta.AddTypeMap("Password", new tgTypeMap("varchar", "System.String"));
meta.Source = "MailPreferences";
meta.Destination = "MailPreferences";
meta.spInsert = "proc_MailPreferencesInsert";
meta.spUpdate = "proc_MailPreferencesUpdate";
meta.spDelete = "proc_MailPreferencesDelete";
meta.spLoadAll = "proc_MailPreferencesLoadAll";
meta.spLoadByPrimaryKey = "proc_MailPreferencesLoadByPrimaryKey";
this.m_providerMetadataMaps["tgDefault"] = meta;
}
return(this.m_providerMetadataMaps["tgDefault"]);
}
private tgProviderSpecificMetadata tgDefault(string mapName)
{
if (!m_providerMetadataMaps.ContainsKey(mapName))
{
tgProviderSpecificMetadata meta = new tgProviderSpecificMetadata();
meta.AddTypeMap("LoginProvider", new tgTypeMap("nvarchar", "System.String"));
meta.AddTypeMap("ProviderKey", new tgTypeMap("nvarchar", "System.String"));
meta.AddTypeMap("UserId", new tgTypeMap("nvarchar", "System.String"));
meta.Source = "AspNetUserLogins";
meta.Destination = "AspNetUserLogins";
meta.spInsert = "proc_AspNetUserLoginsInsert";
meta.spUpdate = "proc_AspNetUserLoginsUpdate";
meta.spDelete = "proc_AspNetUserLoginsDelete";
meta.spLoadAll = "proc_AspNetUserLoginsLoadAll";
meta.spLoadByPrimaryKey = "proc_AspNetUserLoginsLoadByPrimaryKey";
this.m_providerMetadataMaps["tgDefault"] = meta;
}
return(this.m_providerMetadataMaps["tgDefault"]);
}
static public string CreateFullName(tgDataRequest request, tgDynamicQuerySerializable query)
{
IDynamicQuerySerializableInternal iQuery = query as IDynamicQuerySerializableInternal;
tgProviderSpecificMetadata providerMetadata = iQuery.ProviderMetadata as tgProviderSpecificMetadata;
string name = String.Empty;
string catalog = iQuery.Catalog ?? request.Catalog ?? providerMetadata.Catalog;
string schema = iQuery.Schema ?? request.Schema ?? providerMetadata.Schema;
if (catalog != null && schema != null)
{
name += Delimiters.TableOpen + catalog + Delimiters.TableClose + ".";
}
if (schema != null)
{
name += Delimiters.TableOpen + schema + Delimiters.TableClose + ".";
}
name += Delimiters.TableOpen;
if (query.tg.QuerySource != null)
{
name += query.tg.QuerySource;
}
else
{
name += providerMetadata.Destination;
}
name += Delimiters.TableClose;
return(name);
}
private tgProviderSpecificMetadata tgDefault(string mapName)
{
if (!m_providerMetadataMaps.ContainsKey(mapName))
{
tgProviderSpecificMetadata meta = new tgProviderSpecificMetadata();
meta.AddTypeMap("Id", new tgTypeMap("nvarchar", "System.String"));
meta.AddTypeMap("Email", new tgTypeMap("nvarchar", "System.String"));
meta.AddTypeMap("EmailConfirmed", new tgTypeMap("bit", "System.Boolean"));
meta.AddTypeMap("PasswordHash", new tgTypeMap("nvarchar", "System.String"));
meta.AddTypeMap("SecurityStamp", new tgTypeMap("nvarchar", "System.String"));
meta.AddTypeMap("PhoneNumber", new tgTypeMap("nvarchar", "System.String"));
meta.AddTypeMap("PhoneNumberConfirmed", new tgTypeMap("bit", "System.Boolean"));
meta.AddTypeMap("TwoFactorEnabled", new tgTypeMap("bit", "System.Boolean"));
meta.AddTypeMap("LockoutEndDateUtc", new tgTypeMap("datetime", "System.DateTime"));
meta.AddTypeMap("LockoutEnabled", new tgTypeMap("bit", "System.Boolean"));
meta.AddTypeMap("AccessFailedCount", new tgTypeMap("int", "System.Int32"));
meta.AddTypeMap("UserName", new tgTypeMap("nvarchar", "System.String"));
meta.Source = "AspNetUsers";
meta.Destination = "AspNetUsers";
meta.spInsert = "proc_AspNetUsersInsert";
meta.spUpdate = "proc_AspNetUsersUpdate";
meta.spDelete = "proc_AspNetUsersDelete";
meta.spLoadAll = "proc_AspNetUsersLoadAll";
meta.spLoadByPrimaryKey = "proc_AspNetUsersLoadByPrimaryKey";
this.m_providerMetadataMaps["tgDefault"] = meta;
}
return(this.m_providerMetadataMaps["tgDefault"]);
}
private tgProviderSpecificMetadata tgDefault(string mapName)
{
if (!m_providerMetadataMaps.ContainsKey(mapName))
{
tgProviderSpecificMetadata meta = new tgProviderSpecificMetadata();
meta.AddTypeMap("Id", new tgTypeMap("integer", "System.Int32"));
meta.AddTypeMap("Title", new tgTypeMap("text", "System.String"));
meta.AddTypeMap("MazeId", new tgTypeMap("text", "System.String"));
meta.AddTypeMap("Synopsis", new tgTypeMap("text", "System.String"));
meta.AddTypeMap("Image", new tgTypeMap("text", "System.String"));
meta.AddTypeMap("NextAirDate", new tgTypeMap("text", "System.String"));
meta.Source = "TVShows";
meta.Destination = "TVShows";
meta.spInsert = "proc_TVShowsInsert";
meta.spUpdate = "proc_TVShowsUpdate";
meta.spDelete = "proc_TVShowsDelete";
meta.spLoadAll = "proc_TVShowsLoadAll";
meta.spLoadByPrimaryKey = "proc_TVShowsLoadByPrimaryKey";
this.m_providerMetadataMaps["tgDefault"] = meta;
}
return(this.m_providerMetadataMaps["tgDefault"]);
}
static public Dictionary <string, MySqlParameter> GetParameters(Guid dataID,
tgProviderSpecificMetadata providerMetadata, tgColumnMetadataCollection columns)
{
lock (parameterCache)
{
if (!parameterCache.ContainsKey(dataID))
{
// The Parameters for this Table haven't been cached yet, this is a one time operation
Dictionary <string, MySqlParameter> types = new Dictionary <string, MySqlParameter>();
MySqlParameter param1;
foreach (tgColumnMetadata col in columns)
{
tgTypeMap typeMap = providerMetadata.GetTypeMap(col.PropertyName);
if (typeMap != null)
{
string nativeType = typeMap.NativeType;
MySqlDbType dbType = Cache.NativeTypeToDbType(nativeType);
param1 = new MySqlParameter(Delimiters.Param + col.PropertyName, dbType, 0, col.Name);
param1.SourceColumn = col.Name;
switch (dbType)
{
case MySqlDbType.Decimal:
case MySqlDbType.NewDecimal:
case MySqlDbType.Double:
case MySqlDbType.Float:
case MySqlDbType.Int16:
case MySqlDbType.Int24:
case MySqlDbType.Int32:
case MySqlDbType.Int64:
case MySqlDbType.UInt16:
case MySqlDbType.UInt24:
case MySqlDbType.UInt32:
case MySqlDbType.UInt64:
param1.Size = (int)col.CharacterMaxLength;
param1.Precision = (byte)col.NumericPrecision;
param1.Scale = (byte)col.NumericScale;
break;
case MySqlDbType.String:
case MySqlDbType.VarString:
case MySqlDbType.VarChar:
param1.Size = (int)col.CharacterMaxLength;
break;
}
types[col.Name] = param1;
}
}
parameterCache[dataID] = types;
}
}
return(parameterCache[dataID]);
}
static public string CreateFullName(tgProviderSpecificMetadata providerMetadata)
{
string name = String.Empty;
name += Delimiters.TableOpen;
name += providerMetadata.Destination;
name += Delimiters.TableClose;
return(name);
}
static public Dictionary <string, SqlCeParameter> GetParameters(Guid dataID,
tgProviderSpecificMetadata providerMetadata, tgColumnMetadataCollection columns)
{
lock (parameterCache)
{
if (!parameterCache.ContainsKey(dataID))
{
// The Parameters for this Table haven't been cached yet, this is a one time operation
Dictionary <string, SqlCeParameter> types = new Dictionary <string, SqlCeParameter>();
SqlCeParameter param1;
foreach (tgColumnMetadata col in columns)
{
tgTypeMap typeMap = providerMetadata.GetTypeMap(col.PropertyName);
if (typeMap != null)
{
string nativeType = typeMap.NativeType;
SqlDbType dbType = Cache.NativeTypeToDbType(nativeType);
param1 = new SqlCeParameter(Delimiters.Param + col.PropertyName, dbType, 0, col.Name);
param1.SourceColumn = col.Name;
switch (dbType)
{
case SqlDbType.Decimal:
param1.Precision = (byte)col.NumericPrecision;
param1.Scale = (byte)col.NumericScale;
break;
case SqlDbType.DateTime:
param1.Precision = 23;
param1.Scale = 3;
break;
case SqlDbType.SmallDateTime:
param1.Precision = 16;
break;
}
types[col.Name] = param1;
}
}
parameterCache[dataID] = types;
}
}
return(parameterCache[dataID]);
}
static public Dictionary<string, VistaDBParameter> GetParameters(Guid dataID,
tgProviderSpecificMetadata providerMetadata, tgColumnMetadataCollection columns)
{
lock (parameterCache)
{
if (!parameterCache.ContainsKey(dataID))
{
// The Parameters for this Table haven't been cached yet, this is a one time operation
Dictionary<string, VistaDBParameter> types = new Dictionary<string, VistaDBParameter>();
VistaDBParameter param1;
foreach (tgColumnMetadata col in columns)
{
tgTypeMap typeMap = providerMetadata.GetTypeMap(col.PropertyName);
if (typeMap != null)
{
string nativeType = typeMap.NativeType;
VistaDBType dbType = Cache.NativeTypeToDbType(nativeType);
param1 = new VistaDBParameter(Delimiters.Param + col.PropertyName, dbType, 0, col.Name);
param1.SourceColumn = col.Name;
switch (dbType)
{
case VistaDBType.BigInt:
case VistaDBType.Int:
case VistaDBType.SmallInt:
case VistaDBType.Decimal:
case VistaDBType.Float:
case VistaDBType.Money:
case VistaDBType.SmallMoney:
param1.Size = (int)col.CharacterMaxLength;
break;
}
types[col.Name] = param1;
}
}
parameterCache[dataID] = types;
}
}
return parameterCache[dataID];
}
static public string CreateFullName(tgDynamicQuerySerializable query)
{
IDynamicQuerySerializableInternal iQuery = query as IDynamicQuerySerializableInternal;
tgProviderSpecificMetadata providerMetadata = iQuery.ProviderMetadata as tgProviderSpecificMetadata;
string name = String.Empty;
name += Delimiters.TableOpen;
if (query.tg.QuerySource != null)
{
name += query.tg.QuerySource;
}
else
{
name += providerMetadata.Destination;
}
name += Delimiters.TableClose;
return(name);
}
private tgProviderSpecificMetadata tgDefault(string mapName)
{
if (!m_providerMetadataMaps.ContainsKey(mapName))
{
tgProviderSpecificMetadata meta = new tgProviderSpecificMetadata();
meta.AddTypeMap("EmployeeID", new tgTypeMap("integer", "System.Int32"));
meta.AddTypeMap("LastName", new tgTypeMap("nvarchar", "System.String"));
meta.AddTypeMap("FirstName", new tgTypeMap("nvarchar", "System.String"));
meta.AddTypeMap("Title", new tgTypeMap("nvarchar", "System.String"));
meta.AddTypeMap("TitleOfCourtesy", new tgTypeMap("nvarchar", "System.String"));
meta.AddTypeMap("BirthDate", new tgTypeMap("datetime", "System.DateTime"));
meta.AddTypeMap("HireDate", new tgTypeMap("datetime", "System.DateTime"));
meta.AddTypeMap("Address", new tgTypeMap("nvarchar", "System.String"));
meta.AddTypeMap("City", new tgTypeMap("nvarchar", "System.String"));
meta.AddTypeMap("Region", new tgTypeMap("nvarchar", "System.String"));
meta.AddTypeMap("PostalCode", new tgTypeMap("nvarchar", "System.String"));
meta.AddTypeMap("Country", new tgTypeMap("nvarchar", "System.String"));
meta.AddTypeMap("HomePhone", new tgTypeMap("nvarchar", "System.String"));
meta.AddTypeMap("Extension", new tgTypeMap("nvarchar", "System.String"));
meta.AddTypeMap("Photo", new tgTypeMap("blob", "System.Byte[]"));
meta.AddTypeMap("Notes", new tgTypeMap("text", "System.String"));
meta.AddTypeMap("ReportsTo", new tgTypeMap("integer", "System.Int32"));
meta.AddTypeMap("PhotoPath", new tgTypeMap("nvarchar", "System.String"));
meta.Source = "Employees";
meta.Destination = "Employees";
meta.spInsert = "proc_EmployeesInsert";
meta.spUpdate = "proc_EmployeesUpdate";
meta.spDelete = "proc_EmployeesDelete";
meta.spLoadAll = "proc_EmployeesLoadAll";
meta.spLoadByPrimaryKey = "proc_EmployeesLoadByPrimaryKey";
this.m_providerMetadataMaps["tgDefault"] = meta;
}
return(this.m_providerMetadataMaps["tgDefault"]);
}
static public string CreateFullName(tgProviderSpecificMetadata providerMetadata)
{
return(Delimiters.TableOpen + providerMetadata.Destination + Delimiters.TableClose);
}
