Mark Junker
Mark Junker
> I think we could spec out what that ORM-like expression syntax would look like as an Issue, and sticky it as a wish list for someone to go do....
> What about one of these two variants? > > ```cs > Create.Column("x").OnTable("Y").AsBoolean().NotNullable() > .SeedWith( > (Execute exec) => exec.Sql("UPDATE Y SET x = false") > ); > ``` I...
Something like this: ```csharp Create.Column("x").OnTable("Y").AsBoolean().NotNullable() .SeedWith( (IDmlExpression exec) => exec.Sql("UPDATE Y SET x = false") ); ``` with `IDmlExpression` being: ```csharp public interface IDmlExpression : IExecuteExpressionRoot { IDeleteExpressionRoot Delete {...
Yes, you're right about the `Delete` part. I'm not so sure that the `SeedWith` functionality is really useful. I'm always thinking about Firebird where you add a non-nullable column to...
> > I'm always thinking about Firebird where you add a non-nullable column to the table and set the default value with a `UPDATE tableWithNewColumn SET newColumn=newValue WHERE newColumn IS...
Querying the current state of the database doesn't work well with SQL script generation. We have to find a middle ground between PR #664 and this solution.
I propose a service that can do a pre-open and post-open configuration for a connection, as this would allow both changing the connection configuration and applying some commands directly after...
SQLite for example doesn't know time zones 😅
My assumption is that the ADO.NET driver doesn't support `DELIMITER`. I checked it and we're not splitting the SQL commands for MySQL, so it shouldn't be a problem on our...
Might be possible. Maybe we should give it a try and release a fixed 3.x version.