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?

Re: Visual C# Express question by CT

CT
Wed Nov 09 22:04:11 CST 2005

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.

--
Carsten Thomsen
Communities - http://community.integratedsolutions.dk
---------
Voodoo Programming: Things programmers do that they know shouldn't work but
they try anyway, and which sometimes actually work, such as recompiling
everything. (Karl Lehenbauer)
---------
"Lloyd Dupont" <net.galador@ld> wrote in message
news:%23dhTpVa5FHA.3880@TK2MSFTNGP12.phx.gbl...
>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?
>



Re: Visual C# Express question by Lloyd

Lloyd
Wed Nov 09 22:12:07 CST 2005

> 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.
>
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...

> --
> Carsten Thomsen
> Communities - http://community.integratedsolutions.dk
> ---------
> Voodoo Programming: Things programmers do that they know shouldn't work
> but they try anyway, and which sometimes actually work, such as
> recompiling everything. (Karl Lehenbauer)
> ---------
> "Lloyd Dupont" <net.galador@ld> wrote in message
> news:%23dhTpVa5FHA.3880@TK2MSFTNGP12.phx.gbl...
>>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?
>>
>
>



Re: Visual C# Express question by CT

CT
Wed Nov 09 22:46:31 CST 2005

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...

--
Carsten Thomsen
Communities - http://community.integratedsolutions.dk
---------
Voodoo Programming: Things programmers do that they know shouldn't work but
they try anyway, and which sometimes actually work, such as recompiling
everything. (Karl Lehenbauer)
---------
"Lloyd Dupont" <net.galador@ld> wrote in message
news:OEJesza5FHA.156@TK2MSFTNGP15.phx.gbl...
>> 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.
>>
> 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...
>
>> --
>> Carsten Thomsen
>> Communities - http://community.integratedsolutions.dk
>> ---------
>> Voodoo Programming: Things programmers do that they know shouldn't work
>> but they try anyway, and which sometimes actually work, such as
>> recompiling everything. (Karl Lehenbauer)
>> ---------
>> "Lloyd Dupont" <net.galador@ld> wrote in message
>> news:%23dhTpVa5FHA.3880@TK2MSFTNGP12.phx.gbl...
>>>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?
>>>
>>
>>
>
>



Re: Visual C# Express question by Lloyd

Lloyd
Wed Nov 09 23:28:49 CST 2005

> I'd stay with what you have. However, if it is a personal project, you
> might
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...
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!)

>
> --
> Carsten Thomsen
> Communities - http://community.integratedsolutions.dk
> ---------
> Voodoo Programming: Things programmers do that they know shouldn't work
> but they try anyway, and which sometimes actually work, such as
> recompiling everything. (Karl Lehenbauer)
> ---------
> "Lloyd Dupont" <net.galador@ld> wrote in message
> news:OEJesza5FHA.156@TK2MSFTNGP15.phx.gbl...
>>> 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.
>>>
>> 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...
>>
>>> --
>>> Carsten Thomsen
>>> Communities - http://community.integratedsolutions.dk
>>> ---------
>>> Voodoo Programming: Things programmers do that they know shouldn't work
>>> but they try anyway, and which sometimes actually work, such as
>>> recompiling everything. (Karl Lehenbauer)
>>> ---------
>>> "Lloyd Dupont" <net.galador@ld> wrote in message
>>> news:%23dhTpVa5FHA.3880@TK2MSFTNGP12.phx.gbl...
>>>>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?
>>>>
>>>
>>>
>>
>>
>
>



Re: Visual C# Express question by William

William
Thu Nov 10 00:23:11 CST 2005

> 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

What mean by "database is file based"?



Re: Visual C# Express question by CT

CT
Thu Nov 10 01:23:15 CST 2005

Like MS Access; not service/server based...

"Easily move or copy your SQL Server Express databases to another computer
or hosted server using XCopy and ClickOnce deployment." an excerpt taken
from here: http://msdn.microsoft.com/vstudio/express/sql/

--
Carsten Thomsen
Communities - http://community.integratedsolutions.dk
---------
Voodoo Programming: Things programmers do that they know shouldn't work but
they try anyway, and which sometimes actually work, such as recompiling
everything. (Karl Lehenbauer)
---------
"William Stacey [MVP]" <william.stacey@gmail.com> wrote in message
news:%23aGl98b5FHA.3188@TK2MSFTNGP15.phx.gbl...
>> 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
>
> What mean by "database is file based"?
>



Re: Visual C# Express question by William

William
Thu Nov 10 01:54:30 CST 2005

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.

--
William Stacey [MVP]

"CT" <carstent@spammersgoawayintegrasol.dk> wrote in message
news:u82Vfec5FHA.1716@TK2MSFTNGP10.phx.gbl...
> Like MS Access; not service/server based...
>
> "Easily move or copy your SQL Server Express databases to another computer
> or hosted server using XCopy and ClickOnce deployment." an excerpt taken
> from here: http://msdn.microsoft.com/vstudio/express/sql/
>
> --
> Carsten Thomsen
> Communities - http://community.integratedsolutions.dk
> ---------
> Voodoo Programming: Things programmers do that they know shouldn't work
> but they try anyway, and which sometimes actually work, such as
> recompiling everything. (Karl Lehenbauer)
> ---------
> "William Stacey [MVP]" <william.stacey@gmail.com> wrote in message
> news:%23aGl98b5FHA.3188@TK2MSFTNGP15.phx.gbl...
>>> 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
>>
>> What mean by "database is file based"?
>>
>
>



Re: Visual C# Express question by Lloyd

Lloyd
Thu Nov 10 02:12:26 CST 2005

> 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
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.


> 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.
>
> --
> William Stacey [MVP]
>
> "CT" <carstent@spammersgoawayintegrasol.dk> wrote in message
> news:u82Vfec5FHA.1716@TK2MSFTNGP10.phx.gbl...
>> Like MS Access; not service/server based...
>>
>> "Easily move or copy your SQL Server Express databases to another
>> computer or hosted server using XCopy and ClickOnce deployment." an
>> excerpt taken from here: http://msdn.microsoft.com/vstudio/express/sql/
>>
>> --
>> Carsten Thomsen
>> Communities - http://community.integratedsolutions.dk
>> ---------
>> Voodoo Programming: Things programmers do that they know shouldn't work
>> but they try anyway, and which sometimes actually work, such as
>> recompiling everything. (Karl Lehenbauer)
>> ---------
>> "William Stacey [MVP]" <william.stacey@gmail.com> wrote in message
>> news:%23aGl98b5FHA.3188@TK2MSFTNGP15.phx.gbl...
>>>> 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
>>>
>>> What mean by "database is file based"?
>>>
>>
>>
>
>



Re: Visual C# Express question by CT

CT
Thu Nov 10 04:59:28 CST 2005

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. :-)

--
Carsten Thomsen
Communities - http://community.integratedsolutions.dk
---------
Voodoo Programming: Things programmers do that they know shouldn't work but
they try anyway, and which sometimes actually work, such as recompiling
everything. (Karl Lehenbauer)
---------
"Lloyd Dupont" <net.galador@ld> wrote in message
news:esE3%235c5FHA.476@TK2MSFTNGP15.phx.gbl...
>> 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
> 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.
>
>
>> 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.
>>
>> --
>> William Stacey [MVP]
>>
>> "CT" <carstent@spammersgoawayintegrasol.dk> wrote in message
>> news:u82Vfec5FHA.1716@TK2MSFTNGP10.phx.gbl...
>>> Like MS Access; not service/server based...
>>>
>>> "Easily move or copy your SQL Server Express databases to another
>>> computer or hosted server using XCopy and ClickOnce deployment." an
>>> excerpt taken from here: http://msdn.microsoft.com/vstudio/express/sql/
>>>
>>> --
>>> Carsten Thomsen
>>> Communities - http://community.integratedsolutions.dk
>>> ---------
>>> Voodoo Programming: Things programmers do that they know shouldn't work
>>> but they try anyway, and which sometimes actually work, such as
>>> recompiling everything. (Karl Lehenbauer)
>>> ---------
>>> "William Stacey [MVP]" <william.stacey@gmail.com> wrote in message
>>> news:%23aGl98b5FHA.3188@TK2MSFTNGP15.phx.gbl...
>>>>> 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
>>>>
>>>> What mean by "database is file based"?
>>>>
>>>
>>>
>>
>>
>
>