Access to SQL and SQLCe

Unity Engine
1

I build a content creation tool that uses SQLCe to store all of it’s information. Well it’s now time to try and access that data from my scripts. I have a static class that does all of my sql query information such that it’s easy to change what kind of DB I am using. What do I need to include to use SQLCe and if I can’t use SQLCe what are my alternatives? The database file at this point doesn’t really have any data in it and I think converting the schema is trivial. I’m just glad that I didn’t get too deep before realizing that Unity doesn’t support it (as far as I know) can I just include all the DLL files that support SQL ( I don’t know how deep C# runs as a scripting language in Unity so this might not work)

I am using Windows 7 64 bit, with Visual Studio 2010 Pro, I also have 2008 Pro. (And as I look it would appear that i don’t hvaSQL Server management studio installed… guess I’ll go grab the express version while I wait for some help )

2

Dough!! It would appear that I just missed the System.Data.SqlCe as an available reference to add… That list is rather long it’s hard to miss. However, Unity is still complaining that Data does not exist in the namespace System. I added that to my references as well. Visual Studio is happy with everything but Unity isn’t, what am I missing?