Need Suggestion for Replacement DB
-
I'm going to be developing a WPF/C# app that will run on single PC's/Laptops. I have extensive experience with SQL Server, but now I need a replacement DB that I can install and use on the target environment. Again, something similar to SQL would be nice so I keep the learning curve to a minimum. Thanks
If it's not broken, fix it until it is
-
Never used it. I'll take a look
If it's not broken, fix it until it is
-
Know of any tutorials to get me up & running quickly? Thanks!
If it's not broken, fix it until it is
-
I second that.
-
Know of any tutorials to get me up & running quickly? Thanks!
If it's not broken, fix it until it is
Sorry, I started using it for a training app and chucked it because I am so reliant on stored procs it irritated the hell out of me. Coding up all the queries in c# as strings was excruciating. I would seriously look at EF if I had to use it, and I hate EF!
Never underestimate the power of human stupidity RAH
-
Sorry, I started using it for a training app and chucked it because I am so reliant on stored procs it irritated the hell out of me. Coding up all the queries in c# as strings was excruciating. I would seriously look at EF if I had to use it, and I hate EF!
Never underestimate the power of human stupidity RAH
Query strings??? Use Linq to SQL.... no query strings. No sprocs.
If it's not broken, fix it until it is
-
Query strings??? Use Linq to SQL.... no query strings. No sprocs.
If it's not broken, fix it until it is
Never used Linq to SQL so I have no opinion, but does that not emit a Tsql query. I don't have a problem with CRUD coming from the DAL but I end up doing a lot of processing in procs, the industry I am in I guess.
Never underestimate the power of human stupidity RAH
-
Sorry, I started using it for a training app and chucked it because I am so reliant on stored procs it irritated the hell out of me. Coding up all the queries in c# as strings was excruciating. I would seriously look at EF if I had to use it, and I hate EF!
Never underestimate the power of human stupidity RAH
Have a look at SmartPaster[^]. It allows you to build the query in your favourite tool and paste it as a stringbuilder in VS. If you ever get the idea to try again that is. :-\
Wrong is evil and must be defeated. - Jeff Ello[^]
-
Know of any tutorials to get me up & running quickly? Thanks!
If it's not broken, fix it until it is
-
I'm going to be developing a WPF/C# app that will run on single PC's/Laptops. I have extensive experience with SQL Server, but now I need a replacement DB that I can install and use on the target environment. Again, something similar to SQL would be nice so I keep the learning curve to a minimum. Thanks
If it's not broken, fix it until it is
Have you considered SQLite[^]? I have used it a small amount and it seems fairly good as a database engine. As an afterthought, if you write your code in a layered manner you should be ably to create something that is database agnostic. You could then experiment with different databases to see which one suits your needs.
“That which can be asserted without evidence, can be dismissed without evidence.”
― Christopher Hitchens
-
I'm going to be developing a WPF/C# app that will run on single PC's/Laptops. I have extensive experience with SQL Server, but now I need a replacement DB that I can install and use on the target environment. Again, something similar to SQL would be nice so I keep the learning curve to a minimum. Thanks
If it's not broken, fix it until it is
-
I'm going to be developing a WPF/C# app that will run on single PC's/Laptops. I have extensive experience with SQL Server, but now I need a replacement DB that I can install and use on the target environment. Again, something similar to SQL would be nice so I keep the learning curve to a minimum. Thanks
If it's not broken, fix it until it is
At least at one time Microsoft allowed SQL Server to be used for free for smaller businesses. Figuring that out can be difficult but might be worth it. The normal goto for free alternatives is MySQL but you should look at the license for that, but an alternative which might be even better now is one that started as a fork of MySQL which is MariaDB. Those however are 'servers' and an embedded database might serve your application better. But you might want to make sure that your application will never have a need to have multiple clients and one server.