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

newbiewebSr. Software EngineerAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Carl TawnConnect With a Mentor Systems and Integration DeveloperCommented:
SQLite possibly?

    http://www.sqlite.org/
0
 
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
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
systanConnect With a Mentor Commented:
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 TawnConnect With a Mentor Systems 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
All Courses

From novice to tech pro — start learning today.