Database - Storing Connection In A Static Class?

Mar 4, 2010

Since I'm using Postgresql and can't use LINQ to SQL, I wrote my own wrapper classes.

This is a part of the Student class:

[code]....

It works now! I replaces all Run methods in the Student class with DB.Run

But I want to know if it will work fine with a lot of people online, not me only. I'm not sure how static things work with ASP.NET, maybe it'll eat a lot of memory?..

View 3 Replies


Similar Messages:

Storing Data From Database In Static Property?

Mar 25, 2011

I have got an ASP.Net website, where the data is brought in from ISeries.The data connection to ISeries is quite slow and the speed is quite important for this website. Because of the slow speed of data retrieval from ISeries, I want to make as less database connections as possible.So, I was thinking about storing tables from the database which rarely changes as static properties in my website. Whenevera user logs in I submit a thread which refreshes the data in the static property. Is this approach correct? If not, what are the problems with this approach and what are the possible alternatives?

Example:-

For list of ports, I submit the below thread when user logs on:-

[Code]....

In class Ports, there are 2 methods -

one for populating the static property PortList, and the other checks if the thread is alive and waits for the thread to complete and retrieve the list of ports, once it is complete. The second method is the one which I use in my application whenever I need the list of ports (populating a dropdown, etc).

[Code]....

View 1 Replies

C# - How To Lock A Private Static Field Of A Class In One Static Method

Mar 26, 2011

I have a private static field in my Controller class in an MVC web application.

I have a static method in that controller that assigns some value to that static field, I want to apply lock on that static field until some other instance method in the controller uses the value stored in the static field and then releases it.

DETAILS:

I have a controller named BaseController having a static ClientId field as follows and two methods as follows:-

public static string ClientId = "";
static void OnClientConnected(string clientId, ref Dictionary<string, object> list)
{
list.Add("a", "b");
// I want the ClientId to be locked here, so that it can not be accessed by other requests coming to the server and wait for ClientId to be released:-
BaseController.clientId = clientId;
}
public ActionResult Handler()
{
if (something)
{
// use the static ClientId here
}
// Release the ClientId here, so it can now be used by other web requests coming to the server.
return View();
}

View 1 Replies

C# - How To Overload Database Connection Class

Mar 9, 2011

I use the class below in my code-behind to connect to my database. How would I (overload?) this class to choose between multiple connection strings (databases)?

Or should I have a separate class for each connection?

[code]....

View 5 Replies

How To Make Database Connection Class

Jan 19, 2011

how make the class for database activities and it can be used in code behind

coz i want avoid the connection opening, closing activities, insert,update etc methods in code behind frequently.

the class should include connection open and closing method, passing values to stored procedures etc.

How should we construct it?

View 8 Replies

ADO.NET :: Create Class Files When Connection To SQL Database?

Mar 14, 2011

I am new to Visual Studio 2010 and ASP.Net, and when I first connected my SQL Server to Visual Studio it created huge files full of my SQL classes (maybe this was LINQ classes), and I accidently deleted/corrupted those files, and now I want it to create those classes again. Can someone tell me how I can do that?

View 5 Replies

Architecture :: Creating A Separated Class For Database Connection?

Dec 10, 2010

i have the following code:

[Code]....

I was trying to implement as above. How can i call this class from the code behind of my page, and call the methods Open and Close connection ?

How do i instantiate the object ?

View 5 Replies

Put The Database Connection Settings Into A Base Page Class?

Mar 16, 2010

it's possible to put the database connection settings into a base page class so that I can auto-init them on a page. like this document: [URL] but with instructions in VB.net

View 1 Replies

Public Static Variable Declared In Public Static Class MyGlobals In A 'Code File' Template?

Jan 27, 2011

I have a question about C Sharp ASP.NET:Is there a difference (in code speed, resources) between:public static variable declared in public static class MyGlobals in a 'Code File' template;and the variable declared in a normal 'Class File' template;I use this variable in 2 different Class Files and also in _Default Page codebehind cs file.In fact in my case I need about 20 global variables of type List<string>.

View 9 Replies

Making Ado.net Connection Class Or Connection String In Web.config?

Oct 18, 2010

I am preparing for an Access2007 db conversion at the beginning of the year and would like to know what the best process would be for connecting to the sqlserver2005 database. I have read about adding the connection string to the web.config file. I have also read about using ADO.NET and put the connection information into a class and not the web.config file.

I would like to hear from others as to what you have used, are using, or plan on using for a webapp (vs2010), and why so I can get an understanding.

View 3 Replies

Storing A Connection String In A Windows Service?

Nov 5, 2010

Using vb.net/vs.net 2005

I am writing a windows service but normally I write only asp.net apps. In asp.net app I store my connection strings in a web.config file, what is the correct place to store connection strings in a windows service?

View 2 Replies

Configuration :: Storing Connection Strings And URLs For Different Environments?

Aug 4, 2010

What is the best way to store/access connection strings and most importantly the URLs for different environments (dev, validation, production). I'm using ASP.NET 1.1.

View 2 Replies

Web Forms :: Storing Connection String AppSettings In Web Config

Aug 3, 2013

What I have write connection always in web.Config file and Why I can not write the connection in  Application Variable ....

View 1 Replies

Writing And Storing Class Files In VS 2008?

Sep 1, 2010

What is the recommended method of writing and storing class files in VS 2008, I'm using a web application?

View 2 Replies

Static Class In App_Code?

Jan 8, 2010

If a static class is put in App_Code, does that imply only one instance will be created, shared by different http requests?Or each request still brings one request?

View 3 Replies

Architecture :: Finding Pros And Cons Of Static Classes And Variables (particularly A Db Connection)

Jan 11, 2010

So I started working on my first asp.net application that involves logging in and databases, and soon after i started messing around with a static class. I "discovered" that if you make a variable static, all sessions share that variable (I for some reason was originally assuming that each session had its own copy of that "static" class). Anyway, after discovering this I thought to myself "how could this possibly be useful to me" and thought that itmight be a good idea to make a single static database connection for all of the sessions, rather than storing that as a session variable for each session. Does anybody know what would be the pros and cons of this approach?

View 5 Replies

Use A Static DbUtil Class For Web Is It Dangerous?

Oct 4, 2010

is it ok to use something like this in the web:
(my application is on asp.net mvc)

public static class DbUtil
{
public static int Insert(object o, string cs)
{
using (var conn = new SqlConnection(cs))
using (var cmd = conn.CreateCommand())
{
conn.Open();
return Convert.ToInt32(cmd.ExecuteScalar());

[Code]....

View 2 Replies

MVC :: Accessing An Existing Static Class?

Mar 15, 2011

So i have some existing functionality from an older ASP.Net app that is a static class.

Say there's a static method in that class that returns a dataset that I would like to bind to something like a gridview or whatever I can build using MVC3.

View 2 Replies

C# - Access Static Class From Form?

May 10, 2010

I am using <%# MyFormatClass(Eval("fieldname")) %> to display data in a grid view on my page. MyFormatClass works fine, but now I want to move it to a central location that can be used by many pages. When I try to access the class <%# Utils.MyFormatClass(Eval("fieldname")) %> it no longer works. Is this something we are allowed to do?

View 1 Replies

Crystal Reports :: Storing Multiple Data Types In A Class?

Aug 31, 2010

I need help writing a class that will contain three values per item. I'll be passing parameters to a report: Parameter Name, Data type (int, string, date, etc), and Value. When I pass those values to the report using the class they should be in original form (i.e. an integer should be a numeric, a string should be a string, etc.).


I can do it converting the data's value to strings on one end, and reconverting to the original data type on the other, which seems like a lot of runaround. Is there a simple way? Also, if I'm able to store & retrieve the data in it's native format I don't need the "Data type" stored.

View 2 Replies

Way To Generate Links Automatically Via A Static Class

Jun 10, 2010

I would like to generate my links automatically via a static class in each of my aspx pages (or in a common BasePage).Currently I use this:

private const string TEMPLATE =
"~/One.aspx";
public static string Link ()
(
string link = String.Format(TEMPLATE);
return link;
)

But the name of my page, One.aspx is hardcoded. Is it possible to generate the path instead of this hardcoded constant TEMPLATE. You should know that I do not instantiate the class before creating the link.

View 1 Replies

C# - How To Create A Static Array Containing Custom Class

Jan 6, 2010

I have a method that returns an array of custom class objects that are created by parsing a text file. At the moment every time I use it I am rereading the file which isn't very efficient.

What I wat to do is create an array containing the objects when the page loads and store them in an array which can then be used later.

[Code]....

I thought I could create the static object using something like:

static Album myAlbums[] = readArray("Albums.txt");

but I am getting the following error:

A field initializer cannot reference the nonstatic field, method, or property 'B2M._Default.readArray(string)'

I am new to C# so this is probably something dumb. (Feel free to poke fun in my general direction if this is the case!)

View 2 Replies

C# - How To Access Singleton Class's Static Method

Nov 17, 2010

I have some confusion with singleton class, below are my some points:

1.Can singleton class have static method?,if yes then how we call that methods?
2.what is main difference between Static class and Singleton Class?

I have created my singleton class as follows:

[Code]....

In Above class structure I have created two method one is Static and second is non static, When I am trying to access Static Method it gives me compile time error.

How can I use static method of singleton class?

View 7 Replies

Architecture :: Advantage Of Singleton Class Over Static?

Mar 30, 2010

See in below I have writtine a

1. Singleton class Emp1 with Display Method and
2. Static Class with Static Method Display.

What is the advantage of singleton class over Static Class with Static members?

[Code]....

View 9 Replies

C# - Deallocating Memory, Static Class Destructor?

Jan 13, 2011

I have a static class I'm using as my data layer in my website. In this class, I have string arrays that store queried information that I can access later. Here's the part of my class and the method in question:

public static class data_layer
{
ivate static string[] items;
private static string[] description;
//will return description for an item id. if no item id is found, null is returned
public static string getDesc(string key)
[code]....

View 2 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved