Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 418
  • Last Modified:

What free database works best with Silverlight Out of Browser applications

On Windows, a good single user database is Access. You don't need the Access database installed for your program to ue an Access database. So that's a free solution.

SQL Express is also free, but a bear to auto install and configure.

What else can you suggest that's free and easy to install?

I need to run this Silverlight Out of Browser application on a Macintosh as well. So the database needs to be easy (and free)  to also install on a Macintosh.

What options do I have?

newbieweb

0
newbieweb
Asked:
newbieweb
  • 4
  • 3
  • 2
4 Solutions
 
newbiewebSr. Software EngineerAuthor Commented:
Am I dreaming if I say I want the same database on Windows as I want on Macintosh?

BUT, given that I use LINQ and Entity Framework, perhaps those worries are a thing of the past. I can pick the best database for Windows, and with no recoding, could use an entirely different database engine on the Mactintosh.

Am I right that EF4 and L2E allow me to make a unique database decision for each PC platform?

0
 
Carl TawnSystems and Integration DeveloperCommented:
SQLite possibly?

    http://www.sqlite.org/
0
What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

 
systanCommented:
Ok;
I'm sorry, I did not completely read your post.
Yes, use SQLite.
But SQLite is just a Data File, it's not a Data Server.
You can also select PostGreSQL, it's free all the time.
http://www.c-sharpcorner.com/UploadFile/john_charles/UsingPostgreSQLfromMicrosoftNET06042009145024PM/UsingPostgreSQLfromMicrosoftNET.aspx

MYSQL? it's not free when you used the code commercially.
0
 
newbiewebSr. Software EngineerAuthor Commented:
> I'm sorry, I did not completely read your post.
What part did you miss? Desktop? Free?

>But SQLite is just a Data File, it's not a Data Server.
What's that mean exactly? This will not run on a server. It is a client PC Silverlight out of browser application.

> MYSQL? it's not free when you used the code commercially.
Really?!
I thought the whole premise on Open Source was it was free.  That's a surprise!

newbieweb
0
 
Carl TawnSystems and Integration DeveloperCommented:
SQL Lite is a file based SQL implementation designed to be lighweight and run on numerous types of device, including mobile. It doesn't run as a service based product like a full-blown SQL Server installation would. But it sounds like it might be suitable for the type of thing you're suggesting.

MySQL Community Server is free, but Oracle also offer commercial editions which are payed.
0
 
newbiewebSr. Software EngineerAuthor Commented:
Would Entity Framework 4.0 and LINQ work with SQL Lite?
0
 
Carl TawnSystems and Integration DeveloperCommented:
In theory it should, but i have heard of people having problems with it generating the model correctly. May be worth experimenting with a little. The latest  provider for SQLite may work better.
0
 
newbiewebSr. Software EngineerAuthor Commented:
Thanks!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 4
  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now