C# (CSharp) DBMySql DatabaseModel Examples

Example #1

File: MySQLDBStateless.cs Project: bdalldorf/DBMySQLCore

 public static string GenerateStandardUpdateStatement(DatabaseModel model, string primaryKeyFieldName, object primaryKeyValue)
 {
     return($"UPDATE {model.TableName()} SET {GenerateUpdateFields(model)} WHERE {GetDatabaseTableFieldName(model, primaryKeyFieldName)} = {MySQLDBCommon.SetValueForSql(primaryKeyValue)}");
 }

Example #2

File: MySQLDBStateless.cs Project: bdalldorf/DBMySQLCore

 public static string GenerateStandardDeleteStatement(DatabaseModel model, string primaryKeyFieldName, object primaryKeyValue)
 {
     return($"DELETE FROM {model.TableName()} WHERE {GetDatabaseTableFieldName(model, primaryKeyFieldName)} = {MySQLDBCommon.SetValueForSql(primaryKeyValue)}");
 }

Example #3

File: MySQLDBStateless.cs Project: bdalldorf/DBMySQLCore

 public static string GenerateStandardInsertStatement(DatabaseModel model)
 {
     return($"INSERT INTO {model.TableName()} {GenerateInsertFields(model)}");
 }