My quick capture tool is now more interoperable than before, but I have done nothing to solve my own syncing issues. First, I am transitioning from Roam to Logseq. Logseq is mostly at feature parity with Roam, but allows you to store your notes as local markdown files. This is similar to how Obsidian works, but to my knowledge Logseq is the first block-based tool for thought to consume regular markdown files. Roam allows offline graphs, but the data is not stored in readable markdown files.

dt.Columns.Add(p.Name, p.PropertyType);

Well, as C# advances, some features are been more simplified inside the language. One common problem that beginners programmers have is how to deal with nullable variables.

This is a primer to MVVM and is not the 'best way' to do MVVM. Just one way to do it. Essentially you can load up your ViewModel to your View in

If you need to access the connection string directly, you can use code like this:

This solution cannot be used when the last date to consider is dynamic (for example because it is different for different measures). However, if it is possible to create one calculated column for each related fact table that may have a different range of dates to consider, doing so is still a good idea. Every measure will use the flag in the Date table corresponding to the proper fact table. For example, a DatesWithSales flag can be used in Sales measures, whereas a DatesWithPurchases flag can be used in Purchases measures.

p many times a developer does not have control of column names in a table e.g. fi