I want to build an ASP.NET website with Entity Framework 5 but I do not have permission to install SQL Server on my system, is it possible? If yes, how? If not, any alternative, like files etc...
-
do you have permission to install anything? use external binaries/assemblies?Jean-Bernard Pellerin– Jean-Bernard Pellerin2013-05-10 18:59:45 +00:00Commented May 10, 2013 at 18:59
-
2sql server compact edition? microsoft.com/en-us/sqlserver/editions/2012-editions/…Luke Hutton– Luke Hutton2013-05-10 19:00:29 +00:00Commented May 10, 2013 at 19:00
-
@Jean-BernardPellerin : I can install packages in visual studio via nuget, that's all!Rajesh Mishra– Rajesh Mishra2013-05-11 15:45:48 +00:00Commented May 11, 2013 at 15:45
Add a comment
|
3 Answers
If you can't install anything, then I'm afraid you're stuck with embedded databases like SQL Server Compact Edition or Sqlite. (and some NOSQL databases as well, I believe some of them don't require a server)
Just don't forget about one thing - embedded databases usually aren't enough for web environment.
For instance:
https://stackoverflow.com/questions/11591002/how-can-i-use-sqlite-in-a-c-sharp-project
http://www.microsoft.com/en-us/sqlserver/editions/2012-editions/compact.aspx
10 Comments
Mike Christensen
RavenDB seems pretty cool too, messed around with it for a couple hours once.
Mike Christensen
Ah, I thought it was dual-licensed like mySql. So you can't even use it on a web site for free?
walther
@MikeChristensen, as far as I know, only for open source projects.
Mike Christensen
@walther - Did a little digging and it seems you're right. Guess I won't be using that any time soon.
Mike Cole
Agreed, that was a killer for me, too. Too bad they don't have an Express edition or something.
|
You could offload the database platform entirely to a remote Azure database; there's lots of info on this online, but this page might be a good starting point.
1 Comment
Rajesh Mishra
I appreciate your help, will have a look first then will raise further query.
