Visual C# Express question

  • Thread starter Thread starter Lloyd Dupont
  • Start date Start date
L

Lloyd Dupont

I saw that in the data information box:
"you can create and deploy databases as stand-alone files, but with the
powerful features unique to SQL Server 2005"

And what are the installation requirement on the target computer?
Is .NET 2.0 enough?
Or should something else be installed as well? In which case what it is and
how big the install?
 
Lloyd,

With SQL Server Express all you need is the .NET Framework 2.0 as the
database is file based and the data access components are part of the .NET
Framework.
 
With SQL Server Express all you need is the .NET Framework 2.0 as the
database is file based and the data access components are part of the .NET
Framework.
Click to expand...
Hoho.....
I am just about to finish a big personal project using SQLite while I could
have used SQLServerExpress instead.. :-(
What do you think, should I rewrite ?!
There is one feature though which is very nice in SQLite, I could define my
own function (in C#), as in
SELECT myFunction(Column_0), Column_1 FROM aTable;
is this same functionality available in SQLServer Express?

Mmh...
I might staty with SQLite which is very fast and compact anyway...
 
I'd stay with what you have. However, if it is a personal project, you might
want to port it to SQL Server Express, just to see the differences in
implementation? There's no doubt in my mind that there will be a demand for
SQL Server Express now that the Jet database has been "deprecated" by MS...
 
I'd stay with what you have. However, if it is a personal project, you
might
Click to expand...
right I though so.....
want to port it to SQL Server Express, just to see the differences in
implementation? There's no doubt in my mind that there will be a demand
for SQL Server Express now that the Jet database has been "deprecated" by
MS...
Click to expand...
I though so as well ;-)
After I released it! That would be good training.
That and some Avalon lifting!
(It's a personal commercial project, soon to be released!)
 
With SQL Server Express all you need is the .NET Framework 2.0 as the
database is file based and the data access components are part of the .NET
Click to expand...

What mean by "database is file based"?
 
Think your talking about the User Instance feature. It is still service
based, but is a short-cut to automaticaly create the instance and load the
db. After that, it is pretty much like accessing a shared instance using
shared memory. However the restriction is that it is single user based so
not sharable and the user can admin the thing without being admin. It is
pretty cool way to go if you just need a db for your single user app.
 
Think your talking about the User Instance feature. It is still service
based, but is a short-cut to automaticaly create the instance and load the
Click to expand...
is it?
uh.. was CT wrong when he told me the .NET framework was all that's
required?

I'll try for fun but SQLite seems a much better way to go in my case then.
 
Yes, I was wrong. SQL Server Express must be installed on the destination
computer. However, if that is the case, you can use Xcopy deployment. Thanks
for clearing that up William. :-)
 
Back
Top