Looking for a lightweight database to use for a vb win app
-
I have an older vb win app that I wrote in VS2013 because I have install shield that supports it. I used LocalDB for the database and it worked fine. But LocalDB is pretty heavy, I had to write an automated script to install it first, and then used old school TSQL to make the calls. So the customer asked me to upgrade it, make it more modern. I choose SQLite, but EF6 doesn't support migrations or table creation. I really don't want to write older code to support it. Now I'm looking for something else to use. Would like to use MongoDB but them I have to wrote code to install it first which may be easier than using SQLite. On .Net Core, SQLite works great, and I heard some .Net Core features will be available for win apps. Any Suggestions?
If it ain't broke don't fix it Discover my world at jkirkerx.com
-
I have an older vb win app that I wrote in VS2013 because I have install shield that supports it. I used LocalDB for the database and it worked fine. But LocalDB is pretty heavy, I had to write an automated script to install it first, and then used old school TSQL to make the calls. So the customer asked me to upgrade it, make it more modern. I choose SQLite, but EF6 doesn't support migrations or table creation. I really don't want to write older code to support it. Now I'm looking for something else to use. Would like to use MongoDB but them I have to wrote code to install it first which may be easier than using SQLite. On .Net Core, SQLite works great, and I heard some .Net Core features will be available for win apps. Any Suggestions?
If it ain't broke don't fix it Discover my world at jkirkerx.com
LiteDB is a no-install object store for .NET. It's effectively a no-install Mongo. I've used it for relatively small-scale applications with success (relatively few collections, up to a few hundred thousand records per collection). Mind you, object stores are not necessarily the right answer if the data is heavily relational; you might want to stick with LocalDB and optimize your queries.
"Never attribute to malice that which can be explained by stupidity." - Hanlon's Razor
-
LiteDB is a no-install object store for .NET. It's effectively a no-install Mongo. I've used it for relatively small-scale applications with success (relatively few collections, up to a few hundred thousand records per collection). Mind you, object stores are not necessarily the right answer if the data is heavily relational; you might want to stick with LocalDB and optimize your queries.
"Never attribute to malice that which can be explained by stupidity." - Hanlon's Razor
I'll take a look at that. I just have 4 tables that store account names, manufactures and product with a join to pricing. About 500 products, and pricing for every product and account. So the pricing may grow large.
If it ain't broke don't fix it Discover my world at jkirkerx.com
-
I have an older vb win app that I wrote in VS2013 because I have install shield that supports it. I used LocalDB for the database and it worked fine. But LocalDB is pretty heavy, I had to write an automated script to install it first, and then used old school TSQL to make the calls. So the customer asked me to upgrade it, make it more modern. I choose SQLite, but EF6 doesn't support migrations or table creation. I really don't want to write older code to support it. Now I'm looking for something else to use. Would like to use MongoDB but them I have to wrote code to install it first which may be easier than using SQLite. On .Net Core, SQLite works great, and I heard some .Net Core features will be available for win apps. Any Suggestions?
If it ain't broke don't fix it Discover my world at jkirkerx.com
Both VB and C# contain a way of testing mutually exclusive possibilities, the Select Case and Switch clauses respectively. Only one of them works properly.
A Visual Basic Select Case clause, returning a description of how old someone is. The age range for a young person is a tad generous, reflecting the age of the author of this article.