public static Task Create(this ISchemaObject schemaObject, NpgsqlConnection conn) { var writer = new StringWriter(); schemaObject.WriteCreateStatement(new DdlRules(), writer); return(conn.CreateCommand(writer.ToString()).ExecuteNonQueryAsync()); }
/// <summary> /// Write the creation SQL for this ISchemaObject /// </summary> /// <param name="object"></param> /// <param name="rules"></param> /// <returns></returns> public static string ToCreateSql(this ISchemaObject @object, DdlRules rules) { var writer = new StringWriter(); @object.WriteCreateStatement(rules, writer); return(writer.ToString()); }
protected async Task CreateSchemaObjectInDatabase(ISchemaObject schemaObject) { var rules = new DdlRules(); var writer = new StringWriter(); schemaObject.WriteCreateStatement(rules, writer); try { await theConnection.CreateCommand(writer.ToString()) .ExecuteNonQueryAsync(); } catch (Exception e) { throw new Exception("DDL Execution Failure.\n" + writer.ToString(), e); } }