EnterpriseLibrary 2006 DATA ACCESS LAYER

in the class library i written the code name :customer is the lib name

using System;

using System.Collections.Generic;

using System.Text;

namespace Customer

{ class Entites

{

public int inTest;

public int inTest2;

}

}

Now in the Class1.cs i written the code

i am getting the data from the database by using enterprise lib 2006 connection function

now HOW TO BIND THE DATA TO LIST AND RETURN TYPE IS LIST

PLEASE CHECK THE CODE AND REDEFINE THE CODE

using System;

using System.Data ;

using System.Collections.Generic;

using System.Collections.Generic;

using System.Text;

using Microsoft.Practices.EnterpriseLibrary.Data;

using Microsoft.Practices.EnterpriseLibrary.ExceptionHandling;

using Microsoft.Practices.EnterpriseLibrary.Common.Configuration;

using System.Collections;

using System.Xml.Serialization;

using System.Data.Common;

using Customer;

namespace Customer

{

class Class1

{

public List<Entites> getdata(int id)

{

Database db = DatabaseFactory.CreateDatabase("mycon");

System.Data.Common.DbCommand cmd ;

cmd = db.GetStoredProcCommand("GET_CUSTOMER");

cmd.CommandType = CommandType.StoredProcedure;

db.AddInParameter(cmd,"@.CID",System.Data.DbType.Int32,id);

List<Entites> objEntites = new List<Entites>();

using (IDataReader dr = db.ExecuteReader(cmd))

foreach (Entites obj in dr)

{

objEntites.inTest = obj.inTest;--ERROR LINE

// objEntites.Add(obj);

}

return objEntites;

}

}

}

Error 2 foreach statement cannot operate on variables of type 'System.Data.IDataReader' because 'System.Data.IDataReader' does not contain a public definition for 'GetEnumerator' D:\KOTI_PRJS\Enterprise\Customer\Class1.cs 34 13 Customer

Is this related to SSIS? If not, let me know and I'll be happy to move it to a more appropriate forum. If it is, please describe where the problem is occurring in SSIS.

Enterprise Manager on a workstation

Hi
I have a customer who uses SQL running on an SBS2000 server for several
applications. They have asked if
they can install SQL Enterprise manager on a workstation to manage an
Internet booking system they use.
Can anyone suggest any issues with this please? I'm assuming that there's a
licensing issue, but would there also be a network issue?
Regards
Nick
As long as the workstation has a licence to use the SQL Server it can also
use the managing tools.
There are no Networking issues as far as the EM is also only just a client
app with some more features than only quering or manipulating some data.
HTH, Jens Smeyer.
http://www.sqlserver2005.de
"Nick Hill" <please@.dont.use> schrieb im Newsbeitrag
news:d3jfu0$4ft$1$8302bc10@.news.demon.co.uk...
> Hi
> I have a customer who uses SQL running on an SBS2000 server for several
> applications. They have asked if
> they can install SQL Enterprise manager on a workstation to manage an
> Internet booking system they use.
> Can anyone suggest any issues with this please? I'm assuming that there's
> a licensing issue, but would there also be a network issue?
> Regards
> Nick
>
|||There is no problem in principle running Enterprise Manager or any of
the other client tools on a client PC - they are designed for that. You
need either a Client Access Licence or a Processor Licence for the
server.
If you are thinking about access over the Internet however, you won't
have the necessary ports open, except maybe via a secure VPN. You'll
most likely want some kind of remote access solution and then run EM
from there.
David Portas
SQL Server MVP
|||Doesn't MSDE come with the Enterprise Manager and as far as i know the MSDE
is free.
Does that mean that using the Enterprise Manager that MSDE comes with to
connect to another SQL server engine requires a licence?
-Ash
"David Portas" wrote:

> There is no problem in principle running Enterprise Manager or any of
> the other client tools on a client PC - they are designed for that. You
> need either a Client Access Licence or a Processor Licence for the
> server.
> If you are thinking about access over the Internet however, you won't
> have the necessary ports open, except maybe via a secure VPN. You'll
> most likely want some kind of remote access solution and then run EM
> from there.
> --
> David Portas
> SQL Server MVP
> --
>
|||> Doesn't MSDE come with the Enterprise Manager and as far as i know the
> MSDE
> is free.
MSDE comes with OSQL , no EM :-)

> Does that mean that using the Enterprise Manager that MSDE comes with to
> connect to another SQL server engine requires a licence?
But there is a webTool from MS to administer SQl Server Databases with basic
functionality:
http://www.microsoft.com/downloads/d...DisplayLang=en
HTH, Jens Smeyer
http://www.sqlserver2005.de
"Ash Metry" <AshMetry@.discussions.microsoft.com> schrieb im Newsbeitrag
news:033E925D-FB59-4211-BC67-7904A8686A89@.microsoft.com...[vbcol=seagreen]
> Doesn't MSDE come with the Enterprise Manager and as far as i know the
> MSDE
> is free.
> Does that mean that using the Enterprise Manager that MSDE comes with to
> connect to another SQL server engine requires a licence?
> -Ash
> "David Portas" wrote:
|||MSDE does not come with Enterprise Manager. The MSDE license does not cover
using Enterprise Manager.
Geoff N. Hiten
Microsoft SQL Server MVP
"Ash Metry" <AshMetry@.discussions.microsoft.com> wrote in message
news:033E925D-FB59-4211-BC67-7904A8686A89@.microsoft.com...[vbcol=seagreen]
> Doesn't MSDE come with the Enterprise Manager and as far as i know the
> MSDE
> is free.
> Does that mean that using the Enterprise Manager that MSDE comes with to
> connect to another SQL server engine requires a licence?
> -Ash
> "David Portas" wrote:
|||Ya i remember now.
Sorry about that, I posted without thinking.
"Geoff N. Hiten" wrote:

> MSDE does not come with Enterprise Manager. The MSDE license does not cover
> using Enterprise Manager.
> Geoff N. Hiten
> Microsoft SQL Server MVP
> "Ash Metry" <AshMetry@.discussions.microsoft.com> wrote in message
> news:033E925D-FB59-4211-BC67-7904A8686A89@.microsoft.com...
>
>

Enterprise Manager on a workstation

Hi
I have a customer who uses SQL running on an SBS2000 server for several
applications. They have asked if
they can install SQL Enterprise manager on a workstation to manage an
Internet booking system they use.
Can anyone suggest any issues with this please? I'm assuming that there's a
licensing issue, but would there also be a network issue?
Regards
NickAs long as the workstation has a licence to use the SQL Server it can also
use the managing tools.
There are no Networking issues as far as the EM is also only just a client
app with some more features than only quering or manipulating some data.
HTH, Jens Smeyer.
http://www.sqlserver2005.de
--
"Nick Hill" <please@.dont.use> schrieb im Newsbeitrag
news:d3jfu0$4ft$1$8302bc10@.news.demon.co.uk...
> Hi
> I have a customer who uses SQL running on an SBS2000 server for several
> applications. They have asked if
> they can install SQL Enterprise manager on a workstation to manage an
> Internet booking system they use.
> Can anyone suggest any issues with this please? I'm assuming that there's
> a licensing issue, but would there also be a network issue?
> Regards
> Nick
>|||There is no problem in principle running Enterprise Manager or any of
the other client tools on a client PC - they are designed for that. You
need either a Client Access Licence or a Processor Licence for the
server.
If you are thinking about access over the Internet however, you won't
have the necessary ports open, except maybe via a secure VPN. You'll
most likely want some kind of remote access solution and then run EM
from there.
David Portas
SQL Server MVP
--|||Doesn't MSDE come with the Enterprise Manager and as far as i know the MSDE
is free.
Does that mean that using the Enterprise Manager that MSDE comes with to
connect to another SQL server engine requires a licence?
-Ash
"David Portas" wrote:

> There is no problem in principle running Enterprise Manager or any of
> the other client tools on a client PC - they are designed for that. You
> need either a Client Access Licence or a Processor Licence for the
> server.
> If you are thinking about access over the Internet however, you won't
> have the necessary ports open, except maybe via a secure VPN. You'll
> most likely want some kind of remote access solution and then run EM
> from there.
> --
> David Portas
> SQL Server MVP
> --
>|||> Doesn't MSDE come with the Enterprise Manager and as far as i know the
> MSDE
> is free.
MSDE comes with OSQL , no EM :-)

> Does that mean that using the Enterprise Manager that MSDE comes with to
> connect to another SQL server engine requires a licence?
But there is a webTool from MS to administer SQl Server Databases with basic
functionality:
http://www.microsoft.com/downloads/...&DisplayLang=en
HTH, Jens Smeyer
http://www.sqlserver2005.de
--
"Ash Metry" <AshMetry@.discussions.microsoft.com> schrieb im Newsbeitrag
news:033E925D-FB59-4211-BC67-7904A8686A89@.microsoft.com...[vbcol=seagreen]
> Doesn't MSDE come with the Enterprise Manager and as far as i know the
> MSDE
> is free.
> Does that mean that using the Enterprise Manager that MSDE comes with to
> connect to another SQL server engine requires a licence?
> -Ash
> "David Portas" wrote:
>|||MSDE does not come with Enterprise Manager. The MSDE license does not cover
using Enterprise Manager.
Geoff N. Hiten
Microsoft SQL Server MVP
"Ash Metry" <AshMetry@.discussions.microsoft.com> wrote in message
news:033E925D-FB59-4211-BC67-7904A8686A89@.microsoft.com...[vbcol=seagreen]
> Doesn't MSDE come with the Enterprise Manager and as far as i know the
> MSDE
> is free.
> Does that mean that using the Enterprise Manager that MSDE comes with to
> connect to another SQL server engine requires a licence?
> -Ash
> "David Portas" wrote:
>|||Ya i remember now.
Sorry about that, I posted without thinking.
"Geoff N. Hiten" wrote:

> MSDE does not come with Enterprise Manager. The MSDE license does not cov
er
> using Enterprise Manager.
> Geoff N. Hiten
> Microsoft SQL Server MVP
> "Ash Metry" <AshMetry@.discussions.microsoft.com> wrote in message
> news:033E925D-FB59-4211-BC67-7904A8686A89@.microsoft.com...
>
>

Enterprise Manager on a workstation

Hi
I have a customer who uses SQL running on an SBS2000 server for several
applications. They have asked if
they can install SQL Enterprise manager on a workstation to manage an
Internet booking system they use.
Can anyone suggest any issues with this please? I'm assuming that there's a
licensing issue, but would there also be a network issue?
Regards
NickAs long as the workstation has a licence to use the SQL Server it can also
use the managing tools.
There are no Networking issues as far as the EM is also only just a client
app with some more features than only quering or manipulating some data.
HTH, Jens Süßmeyer.
--
http://www.sqlserver2005.de
--
"Nick Hill" <please@.dont.use> schrieb im Newsbeitrag
news:d3jfu0$4ft$1$8302bc10@.news.demon.co.uk...
> Hi
> I have a customer who uses SQL running on an SBS2000 server for several
> applications. They have asked if
> they can install SQL Enterprise manager on a workstation to manage an
> Internet booking system they use.
> Can anyone suggest any issues with this please? I'm assuming that there's
> a licensing issue, but would there also be a network issue?
> Regards
> Nick
>|||There is no problem in principle running Enterprise Manager or any of
the other client tools on a client PC - they are designed for that. You
need either a Client Access Licence or a Processor Licence for the
server.
If you are thinking about access over the Internet however, you won't
have the necessary ports open, except maybe via a secure VPN. You'll
most likely want some kind of remote access solution and then run EM
from there.
--
David Portas
SQL Server MVP
--|||> Doesn't MSDE come with the Enterprise Manager and as far as i know the
> MSDE
> is free.
MSDE comes with OSQL , no EM :-)
> Does that mean that using the Enterprise Manager that MSDE comes with to
> connect to another SQL server engine requires a licence?
But there is a webTool from MS to administer SQl Server Databases with basic
functionality:
http://www.microsoft.com/downloads/details.aspx?FamilyID=c039a798-c57a-419e-acbc-2a332cb7f959&DisplayLang=en
HTH, Jens Süßmeyer
--
http://www.sqlserver2005.de
--
"Ash Metry" <AshMetry@.discussions.microsoft.com> schrieb im Newsbeitrag
news:033E925D-FB59-4211-BC67-7904A8686A89@.microsoft.com...
> Doesn't MSDE come with the Enterprise Manager and as far as i know the
> MSDE
> is free.
> Does that mean that using the Enterprise Manager that MSDE comes with to
> connect to another SQL server engine requires a licence?
> -Ash
> "David Portas" wrote:
>> There is no problem in principle running Enterprise Manager or any of
>> the other client tools on a client PC - they are designed for that. You
>> need either a Client Access Licence or a Processor Licence for the
>> server.
>> If you are thinking about access over the Internet however, you won't
>> have the necessary ports open, except maybe via a secure VPN. You'll
>> most likely want some kind of remote access solution and then run EM
>> from there.
>> --
>> David Portas
>> SQL Server MVP
>> --
>>|||MSDE does not come with Enterprise Manager. The MSDE license does not cover
using Enterprise Manager.
Geoff N. Hiten
Microsoft SQL Server MVP
"Ash Metry" <AshMetry@.discussions.microsoft.com> wrote in message
news:033E925D-FB59-4211-BC67-7904A8686A89@.microsoft.com...
> Doesn't MSDE come with the Enterprise Manager and as far as i know the
> MSDE
> is free.
> Does that mean that using the Enterprise Manager that MSDE comes with to
> connect to another SQL server engine requires a licence?
> -Ash
> "David Portas" wrote:
>> There is no problem in principle running Enterprise Manager or any of
>> the other client tools on a client PC - they are designed for that. You
>> need either a Client Access Licence or a Processor Licence for the
>> server.
>> If you are thinking about access over the Internet however, you won't
>> have the necessary ports open, except maybe via a secure VPN. You'll
>> most likely want some kind of remote access solution and then run EM
>> from there.
>> --
>> David Portas
>> SQL Server MVP
>> --
>>