469,950 Members | 1,450 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,950 developers. It's quick & easy.

Static class method return non-static object?

Hi,

I have a class which all its attributes, properties and
methods are static.

However, I want a method to return an object that should
be non-static.

Is that possible?

thx,
Pascal
Nov 16 '05 #1
10 5950
Hi,

That's perfectly possible and is, for example, used in implementation of the
Singleton design pattern when a static property returns an instance of the
same class.

--
Sincerely,
Dmitriy Lapshin [C# / .NET MVP]
Bring the power of unit testing to the VS .NET IDE today!
http://www.x-unity.net/teststudio.aspx

"Paschalis Pagonidis" <an*******@discussions.microsoft.com> wrote in message
news:4a****************************@phx.gbl...
Hi,

I have a class which all its attributes, properties and
methods are static.

However, I want a method to return an object that should
be non-static.

Is that possible?

thx,
Pascal


Nov 16 '05 #2
Paschalis Pagonidis <an*******@discussions.microsoft.com> wrote:
I have a class which all its attributes, properties and
methods are static.

However, I want a method to return an object that should
be non-static.

Is that possible?


Objects themselves aren't static or non-static - the concept just
doesn't apply. Could you give more details about what you're trying to
do?

--
Jon Skeet - <sk***@pobox.com>
http://www.pobox.com/~skeet
If replying to the group, please do not mail me too
Nov 16 '05 #3
Hi Dmitriy,

can you give me an example?

for example:
public class MyClass
{
public static object CreateObject()
{
// I want obj to be non-static
object obj = new object();

return obj;
}

thanks,
Pascal
-----Original Message-----
Hi,

That's perfectly possible and is, for example, used in implementation of theSingleton design pattern when a static property returns an instance of thesame class.

--
Sincerely,
Dmitriy Lapshin [C# / .NET MVP]
Bring the power of unit testing to the VS .NET IDE today!
http://www.x-unity.net/teststudio.aspx

"Paschalis Pagonidis" <an*******@discussions.microsoft.com> wrote in messagenews:4a****************************@phx.gbl...
Hi,

I have a class which all its attributes, properties and
methods are static.

However, I want a method to return an object that should
be non-static.

Is that possible?

thx,
Pascal


.

Nov 16 '05 #4
I have a Database class that manages all database related
functionality.

For example instead of initializing SqlDataReader
variables each time in my whole project, I use commands
such as the following:

SqlDataReader data = Database.Execute
("MyStoredProc", "MyParams");

Database class has a static Connection variable which is
used in all forms. Furthermore all Database
constructors/properties/attributes/methods are static.

My problem is that the Execute command returns a static
SqlDataReader object, so I cannot re-execute a sql connand
inside a data.Read() loop:

while (data.Read())
{
data2 = Database.Execute(...); // <-- runtime error
occurs because data is already open.
}
data.Close();
// now that I closed data I can execute again...

thanks,
Pascal

-----Original Message-----
Paschalis Pagonidis <an*******@discussions.microsoft.com> wrote:
I have a class which all its attributes, properties and
methods are static.

However, I want a method to return an object that should be non-static.

Is that possible?


Objects themselves aren't static or non-static - the

concept justdoesn't apply. Could you give more details about what you're trying todo?

--
Jon Skeet - <sk***@pobox.com>
http://www.pobox.com/~skeet
If replying to the group, please do not mail me too
.

Nov 16 '05 #5
>
My problem is that the Execute command returns a static
SqlDataReader object, so I cannot re-execute a sql connand
inside a data.Read() loop:


no that is not your problem. like Jon said, there is NO such thing as an
object being static. There is absolutely no difference between a DataReader
returned from a static method vs. an instance method. your problem is
probably that DataReader keeps the underlying connection tied up to fetch
data, you'd have to use a second connection to execute another command.

this is also a quite expensive way of doing things, you should look into
joins to get all the data in one go if possible, rather than keep going back
to the database. or use disconnected dataset rather than having a datareader
tying up the connection for a prolonged period of time.
Nov 16 '05 #6
-----Original Message-----

My problem is that the Execute command returns a static
SqlDataReader object, so I cannot re-execute a sql connand inside a data.Read() loop:

no that is not your problem. like Jon said, there is NO

such thing as anobject being static. There is absolutely no difference between a DataReaderreturned from a static method vs. an instance method. your problem isprobably that DataReader keeps the underlying connection tied up to fetchdata, you'd have to use a second connection to execute another command.
this is also a quite expensive way of doing things, you should look intojoins to get all the data in one go if possible, rather than keep going backto the database. or use disconnected dataset rather than having a datareadertying up the connection for a prolonged period of time.
.


thanks Daniel,
I think the most appropriate way (and less "expensive" in
terms of code changes) is to use disconnected datasets.
Nov 16 '05 #7
Paschalis Pagonidis <an*******@discussions.microsoft.com> wrote:
I have a Database class that manages all database related
functionality.

For example instead of initializing SqlDataReader
variables each time in my whole project, I use commands
such as the following:

SqlDataReader data = Database.Execute
("MyStoredProc", "MyParams");

Database class has a static Connection variable which is
used in all forms.
That sounds like a bad idea. Connection pooling should be used to
handle this - I suspect getting rid of this will help you a great deal.
Furthermore all Database
constructors/properties/attributes/methods are static.

My problem is that the Execute command returns a static
SqlDataReader object


As I said before, an object isn't static or non-static. What do you
mean by the above?

--
Jon Skeet - <sk***@pobox.com>
http://www.pobox.com/~skeet
If replying to the group, please do not mail me too
Nov 16 '05 #8
Paschalis Pagonidis <an*******@discussions.microsoft.com> wrote:
I have a Database class that manages all database related
functionality.

For example instead of initializing SqlDataReader
variables each time in my whole project, I use commands
such as the following:

SqlDataReader data = Database.Execute
("MyStoredProc", "MyParams");

Database class has a static Connection variable which is
used in all forms.
That sounds like a bad idea. Connection pooling should be used to
handle this - I suspect getting rid of this will help you a great deal.
Furthermore all Database
constructors/properties/attributes/methods are static.

My problem is that the Execute command returns a static
SqlDataReader object


As I said before, an object isn't static or non-static. What do you
mean by the above?

--
Jon Skeet - <sk***@pobox.com>
http://www.pobox.com/~skeet
If replying to the group, please do not mail me too
Nov 16 '05 #9
Yeah, refer to the code as follows

public class MyClass
{
// Private constructor prevents instantiation
private MyClass()
{
i=12;
}
private int i;
static int x=0;
static MyClass ob;
// Because of the private constructor, use this method
// to obtain a reference to this class.
public static MyClass MyMethod()
{
if (x==0){
ob=new MyClass();
x++;}
return ob;
}
}
with regards,
J.V.Ravichandran
- http://www.geocities.com/
jvravichandran
- http://www.411asp.net/func/search?
qry=Ravichandran+J.V.&cob=aspnetpro
- http://www.southasianoutlook.com
- http://www.MSDNAA.Net
- http://www.csharphelp.com
- http://www.poetry.com/Publications/
display.asp?ID=P3966388&BN=999&PN=2
- Or, just search on "J.V.Ravichandran"
at http://www.Google.com

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 16 '05 #10
Yeah, refer to the code as follows

public class MyClass
{
// Private constructor prevents instantiation
private MyClass()
{
i=12;
}
private int i;
static int x=0;
static MyClass ob;
// Because of the private constructor, use this method
// to obtain a reference to this class.
public static MyClass MyMethod()
{
if (x==0){
ob=new MyClass();
x++;}
return ob;
}
}
with regards,
J.V.Ravichandran
- http://www.geocities.com/
jvravichandran
- http://www.411asp.net/func/search?
qry=Ravichandran+J.V.&cob=aspnetpro
- http://www.southasianoutlook.com
- http://www.MSDNAA.Net
- http://www.csharphelp.com
- http://www.poetry.com/Publications/
display.asp?ID=P3966388&BN=999&PN=2
- Or, just search on "J.V.Ravichandran"
at http://www.Google.com

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 16 '05 #11

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Phil Powell | last post: by
21 posts views Thread by Jon Slaughter | last post: by
17 posts views Thread by baibaichen | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.