RepoDB doesn't merge correct after altering a column

Question

With RepoDB I:

SqlServerBootstrap.Initialize();
using (var cnt = new SqlConnection(connectionString))
{
    cnt.ExecuteNonQuery("DROP TABLE IF EXISTS example");
    cnt.ExecuteNonQuery("CREATE TABLE example(Id int NOT NULL PRIMARY KEY, Data nvarchar(1));");
    cnt.Merge("example", new { Id = 1, Data = "a" });  //Adds a row
    cnt.ExecuteNonQuery("ALTER TABLE example ALTER COLUMN Data nvarchar(10);\n ALTER TABLE example ADD Name nvarchar(10);");
    cnt.Merge("example", new { Id = 1, Data = "Long_word", Name = "A_name" });  //Updates the same row
};

Result: Id = 1 Data = "Lo", Name = NULL

Expected: Id = 1 Data = "Long_word", Name = "A_name"

So RepoDB doesn't know that I have altered two columns. Is there a Flush() or Refresh(), so I can get RepoDB to know that I have made changes? Or can I write into RepoDB, what changes I have made?

I have now asked the same question on github and will come back with a solution if any: https://github.com/mikependon/RepoDB/issues/966 — Kenneth Bo Christensen, Oct 21 '21 at 11:01

score 0 · Accepted Answer · answered Oct 21 '21 at 11:14

I got a quick answer at github.

Flush these ones and it worked:

DbFieldCache.Flush(); // Remove all the cached DbField
FieldCache.Flush(); // Remove all the cached DbField
IdentityCache.Flush(); // Remove all the cached DbField
PrimaryCache.Flush(); // Remove all the cached DbField

RepoDB doesn't merge correct after altering a column

1 Answers1