Static Classes For Database Access?

Feb 8, 2010

I am using DataClassesDataContext to map all the tables from the db into my asp.net application.For doing CRUD operations i have made static classes with methods, and inside every method a instantiate DataClassesDataContext.For instance:

public static class UserQ
{
public static User getUserById(int userId)

[code]...

View 3 Replies


Similar Messages:

C# - What Are The Pros/cons Of Choosing Between Static And Instance Data Access Classes In A Web App

Jan 20, 2010

I've read several other questions on this topic (here, here, and here), but have yet to see a great answer. I've developed my fair share of data access layers before and personally prefer to use instance classes instead of static classes. However, it is more of a personal preference (I like to test my business objects, and this approach makes mocking out the DAL easier). I have used static classes to access the database before, but I've always felt a little insecure in the appropriateness of such a design (especially in an ASP.NET environment).

Can anyone provide some good pros/cons with regards to these two approaches to developing data access classes with ADO.NET providers (no ORM), in an ASP.NET application in particular. Feel free to chime in if you have some more general static vs. instance class tips as well.

In particular, the issues I'm concerned about are:

Threading & concurrency
Scalability
Performance
Any other unknowns

View 4 Replies

Could/Should Use Static Classes In C# For Shared Data?

May 7, 2010

I'm building an online system to be used by school groups. Only one school can log into the system at any one time, and from that school you'll get about 13 users. They then proceed into a educational application in which they have to co-operate to complete tasks, and from a code point of view, sharing variables all over the place.

I was thinking, if I set up a static class with static properties that hold the variables that are required to be shared, this could save me having to store/access the variables in/from a database, as long as the static variables are all properly initialized when the application starts and cleaned up at the end. Of course I would also have to put locks on the get and set methods to make the variables thread safe.

Something in the back of my mind is telling me this might be a terrible way of going about things, but I'm not sure exactly why, so if people could give me their thoughts for or against using a static class in this situation,

View 1 Replies

C# - Is It Safe To Access .net Session Variables Through Static Properties Of A Static Object

May 10, 2010

Is it safe to access asp.net session variables through static properties of a static object?Here is what I mean:

public static class SessionHelper
{
public static int Age
{
get
{
[code]...

Is it possible that userA could access userB's session data this way?

View 2 Replies

How To Get Classes To Expose The Same Shared / Static Method

Mar 4, 2010

I have a base class with several derived classes. I want all of my derived classes to have the same Public Shared (static) method with their own implementation. How do I do this?

View 3 Replies

State Management :: Caching With Static Classes?

Jul 3, 2010

Currently I have my data cached in Datasets in a static class. I was talking to my cousin's husband, who works as a C# developer for our local Telecom company.

Basically, I'm pretty new to ASP.NET and although to me having cached data in a static class makes sense to me, when I talked to him about it, he said there might be a problem when the site goes live, as on a web server more than one instance of the class may be created.

He did say this was a theory, and it was an area he didn't know an awful lot about, so I thought I'd ask some of you ASP.NET gurus to see if what I've done is totally wrong or not.

View 12 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

Using Extension Methods In Static Methods On Extended Classes?

Aug 16, 2010

I have an extension method as follows:

public static class PageExtensions
{
public static int GetUserId(this Page targetPage)
{
var user = Membership.GetUser(targetPage.User.Identity.Name);
return (int)user.ProviderUserKey;
}
}

Now in a page I need to use this method in a static WebMethod, so I have added another 'extension method' to PageExtensions:

public static int GetUserId()
{
return (int)Membership.GetUser(HttpContext.Current.User.Identity.Name).ProviderUserKey;
}

and I call it as follows in my WebMethod: PageExtensions.GetUserId()

View 1 Replies

Oop - Use Data Access Classes (Converting From ColdFusion)

Feb 17, 2011

We're converting from ColdFusion to ASP.NET 4.0 and we just don't know which route to take with setting up our classes.

In college I was taught to break everything up into separate Data Access Classes and Entity Classes that speak to the DAC. To me, that's the best option for a team that needs a lot of control over their classes and needs to reuse multiple items.

Then there is LINQ... Sure.. It's great and fast! I have no problems writing my own queries though. To me, it's not something I really need.

I would think we should be using folders that contain our DAClasses and folders that contain our Entity Classes. Then we would have our actual .aspx presentation pages.

View 1 Replies

Unable To Access Classes From Different Files In VB.NET Website?

Jun 9, 2010

I've inherited a VB.NET website and it won't compile because the class1 in the file class1.vb refers to class2 in a file called class2.vb. I get the following error when trying to compile: Type Class2 is not defined.

When I look in the object browser the classes are listed separately (i.e. not all grouped under the same namespace) and appear as:

Public Class Class
Inherits System.Object
Member of C:...mywebsite [code]....

View 2 Replies

Web Forms :: How To Access Classes Or Their Members From App_Code Folder

Apr 27, 2010

I have a single project. and I have two folder in it. In the 1st folder I have a class named Class1 and in the 2nd folder I have a class named Class2. Can anyone tell me how I can access members of Class1 in Class2. I have tried by adding namespace in Class1 and Using that namespace in Class2. But it is giving error. It is easy to access classes or their members from App_Code folder. I don't want to put my classes in app_code folder.

View 5 Replies

Architecture :: Should Let External Classes Access Webform Controls

Sep 24, 2010

I was wondering if you should write code so that external classes and functions of that external class can access the webform controls in the main class???

Or should you only use the external class to process some data, return that data back to the main class (that instantiated that external class object) and then have an internal function in the main class to deliver the data to the control? (back to the screen)

View 2 Replies

Web Forms :: How To Access User Control From App_Code Classes

Jan 28, 2010

I have create a user control. now i want to crate instance of that user contorl in App_Code floder Class.

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

Javascript - Access Gridview In Static Method?

Sep 1, 2010

I want to access my gridview in the static method? I am doing async call from javascript, I need code for this,

[System.Web.Services.WebMethod()]
public static void bindGrid(string userinfoId, int row)
{
GridView gv;
gv = (GridView)gvParent.Rows[row - 1].FindControl("gvChild");
gv.DataSource = GetProfileData(userinfoId);
gv.DataBind();
}

i want to access grid view,gridview is not static. I want to know, Is their any possiblity for using gridview in static method.? Yes or No.

View 1 Replies

Web Forms :: How To Access Session In Static Methods

Sep 15, 2010

I write a simple static method in my web page. How can i access session["id"] into method? I dont have access.For example:

public static void myFunc()
{
Session["id"]= 100;
}

View 2 Replies

C# - Making Cache Access Methods Static?

Nov 12, 2010

In ASP.NET, is there any reason not to make a set of functions that Add/Remove/Get from the Cache object Static?Get() - just gets the item, no reason not to be staticAdd(), Remove() - I've read that adding/deleting into the cache has it's own internal locking mechanism, so they can be static without me creating my own lock(){} wrapping.

View 1 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

Access Global.asax Static Members?

Dec 30, 2010

If we declare a static variable in Global.asax then how to access it inside an ASP.NET page ?

<script runat=server">
public static object myObject = new MyClass();
// Application_Start() and other stuff goes here.
</script>

And, is this a good idea for storing a global object (same instance for all requests) ?

View 3 Replies

Web Forms :: Access Value Of QueryString Value In Static WebMethod?

Feb 25, 2016

my Requirement is: when user clicks on search button ,i need to call a ajax post method from client side and have to access the request.querystring(to get some info of logged customer) in static web method?

Tried things:

1.unable to access the request.querystring in static web method

2.saving the request.qerystring data into viewstate/hidden filed,but unable to access non static fileds in static method?

View 1 Replies

Web Forms :: Access Value Of HiddenField In Static WebMethod

Sep 20, 2015

I am developing a application in which I return the value a it will fine it give me value during debug when I put cursor on .value it give me HiddenField1.Value 140 value but how I get this value into jquery  code I will try a code but every time give me empty value means this value can’t assign to grid view following my whole code

var HiddenField1 = a;////////////////////////C# code where give me value of a
HiddenField1.Value = a.ToString();

My hidden field and Function to access the hidden field value

<asp:HiddenField ID="HiddenField1" runat="server" value="" />
Method to access the hidden field value in Jquery code.
var HiddenFieldcheck= $('#HiddenField1').val();
alert($('[id*=HiddenFieldcheck]').val());

but every time it give a empty value how I solve it ...

View 1 Replies

Visual Studio :: Unable Access To Classes From Other Folders Out Side Project Files

Jan 24, 2010

im facing problem to access classes out side my project folders. for example if i want to use some methods from store.vb file inside my project i get error : Name Space is not defiend, i have tried all ways such as import sdf.ITracjer.Data

[Code]....

i can't fetch the Store Class Methods or Function because its out of project directory, as its showin in image.

View 3 Replies

Access Static Class Properties From Aspx Page?

Jan 28, 2010

I am on .aspx page and i want to take the width and height of a control from a static class
where i have defined them as constans.

Is there any way to access that class directly from the aspx page?

I know that i can make a method like:

width="<%= getWidthSize() %>"

and inside the aspx.cs to define this method to take the size from that static class.

But i am asking if this could be directly managed from the web aspx page...?

View 2 Replies

Architecture :: Use STATIC Methods In Data Access Layer?

Feb 4, 2011

I am developing a web application, which has Data Access Layer and this layer has only one class, in which all methods are static methods like static Insert, static Update, static Search. It has no properties. I am using these methods in my Bussiness Logic class for my users who are visiting my website.Now my question is : 1. Is it right to use static methods in this scenario ?2. What will happen if 10 users call Insert method at the same time ?

View 3 Replies

Web Forms :: How To Access The Page Controls In Static Methods

Oct 4, 2010

How to access the page controls in Static methods.

View 2 Replies







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