.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

is there any impact of using static methods in Business Access layer in 3 tier applciation

Posted By:      Posted Date: August 27, 2010    Points: 0   Category :ASP.Net

is there any impact of using static methods in Business Access layer in 3 tier applciation,

Please suggest me what are the best practices and standards

View Complete Post

More Related Resource Links

Need help: "Adding Parameterized Methods to the Data Access Layer"

Hi all, em all new in C# and .NET.I am following this tutorial: http://www.asp.net/data-access/tutorials/creating-a-data-access-layer-csAnd i am at step 3: Adding Parameterized Methods to the Data Access Layer - i have No problems in getting out all information from my database.But when i try to get a specific item by CategoryID i get a Error.This is what i type in my Query in the table adapter:SELECT     ProductID, ProductName, SupplierID, CategoryID, QuantityPerUnit, UnitPrice, UnitsInStock, UnitsOnOrder, ReorderLevel, DiscontinuedFROM         ProductsWHERE CategoryID = @CategoryIDHere is the error i get when i click finish:The wizard detected the following problems when configuring TableAdapter Query "FillByCategoryID":Details:             Generated SELECT statement.              Error in WHERE clause near '@'.              Unable to parse query text.Can anyone help me with this problem?Someone who knows what i am doing wrong?Thanks

Server.MapPath dont have access to web all calls made in business layer


Hi Guys,

I'm trying to find a way to map a path to a pdf object in my business layer.. im using nop commerce and their messagemanager class is in the business layer and all calls to email queuing and the like are done in the business layer..

i would love to know if there's a way to do it without having the ability to pass the path in from the web layer..

my backup plan is an appsetting in web.config.. but hoped it wouldn't come to that?!

Easy UI Testing: Isolate Your UI Code Before It Invades Your Business Layer


The User Interface Process Application Block (UIP) from the Microsoft Patterns & Practices team can help you isolate your UI, write unit tests for your UI logic, and write a UI that really is the thin layer it was always meant to be. Mark Seemann shows you how it's done in this article.

Mark Seemann

MSDN Magazine August 2005

Data Access: Implement a Data Access Layer for Your App with ADO.NET


Implementing data access functionality is a core activity of most developers working with the .NET Framework, and the data access layers they build are an essential part of their applications. This article outlines five ideas to consider when building a data access layer with Visual Studio .NET and the .NET Framework. The tips include taking advantage of object-oriented techniques and the .NET Framework infrastructure by using base classes, making classes easily inheritable by following guidelines, and carefully examining your needs before deciding on a presentation method and external interface.

Dan Fox

MSDN Magazine April 2003

What is the difference between component,tier and layer?

We often heard about these word  like component, tier, layer of an asp.net application. Please explain the difference between  component , tier and layer?We often heard about these word  like component, tier, layer of an asp.net application.Please explain the difference between  component , tier and layer?

ASP.NET: Using a static class and methods for the WCF client

Traditionally in our web pages we have instantiated a service client in each page and then called the WCF methods from that instance, adding some caching code to check if the data exists and if not, make the WCF call and cache the data for the next time. As our site grows we find we're repeating this same pattern and are looking to move it all to a single class. Can we make that class static, with a single static instance of the WCF client, and static methods, safely? // pseudo-code // assume WcfDataService has a GetFoo(int i) method public static class WcfMethods { public static WcfDataService client = new WcfDataService("connectionType"); public static DataSet GetFoo(int i) { if (Cache["foo" + i] == null) { Cache.Insert("foo" + i, client.GetFoo(i)); } return Cache["foo" + i] as DataSet; } } Then in our pages we can just call WcfMethods.GetFoo(x) directly.  Figure we have 100 users visiting our various pages simultaneously.  Will this cause contention issues?  Like I mentioned, up till now we've not used static instances.  It's not caused any problems, but we're just looking to refactor.  I realize we could also use the above pseudo-code pattern using an instance class and methods instead static ones. I haven't dealt with threading or synchro

Issue with Data Access Layer DLL

Hi, I am working on a project in which I have made changes to LINQ to SQL code in data access layer project. Initially the code was using Single() extension method, I have changed it to SingleOrDefault() was earlier method was throwing exception if no records found in db. After making changes I ran the project but during debugging VS 2008 was showing that file is changed and do you want to reload the file box. When selected the file, the debugger was still executing the commented code (Single() method). I tried cleaning the entire solution and rebuilding it but it did not help. All the projects (Presentation, BL, DAL) are under single solution. Can any one please help me to solve the issue? Thanks in advance.

Not able to access Class methods when deployed on a remote server?

I have a web service project. In the project I have a class named "Piper"In testing the web service in localhost mode in the VS IDE, I can access membersof the class, such as my method "Proceed" and property "Comber" The problem I am having is that when the web service is deployed to the serverin staging, or the deployment server, I am not able to access any methods of my class. Onlythe properties. This is very strange? As they are both public and I can access them when I run the project in local host in the IDE. Does anyone know what the problem might be?Here is a simplified example of my class. Public Class Piper Public Sub Proceed() End Sub Public Property Comber() As Boolean  Get   Return True  End Get  Set(ByVal value As Boolean)       _comber = value  End SetEnd Property End Class

Cannot access public methods on MasterPage

Hi All, maybe someone can help me with this one. I have a a public method in my code behind on the site.master pagenamespace PROJECT { public partial class Site : System.Web.UI.MasterPage { protected void Page_Load(object sender, EventArgs e) { } public void applyUserRole(string userID) { } } } I  wish to call applyUserRole() from Default.aspx On Default.aspx I have .. <%@ Page Language="C#" MasterPageFile="Site.Master" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" Title="Project- Home" %> <%@ MasterType virtualPath="~/Site.master" %> But when I go to Default.aspx.cs and type Master. the method is not appearing. I've seen other post where people are having this issue but I can't find an answer. If anyone has any good pointer and you please let me know, thanks 

A SOA based Customizable Data Access Layer.Please comment

Hi, Actually I have an idea  to built a reusable package software .. The detail mentioned below.. ------------------------------------------------------------------------------------------ A SOA based Customizable Data Access Layer. Data access layer (DAL) is an essential part of almost every project. A data access layer can be build with all required methods(Like methods for fetching, inserting, updating data and also other methods can be built with required number of input parameters, which execute stored procedures.) in any language. Interfacing with the DAL would be a webservice. A webservice can be build with webmethods. The web service contains all web methods, which call all the methods in DAL, passing the appropriate parameters. Addition to those methods, webservice contains a method which takes database details as input parameters and passes the parameters to the method in DAL, which makes connection with database. Thus, the DAL layer and webservice, as a whole are acting as a complete package If the DAL and webservice can be built one time, it can be reused in any project with out modifying it.As the webservice is platform independent and language independent, any project can access the project/software for data operation. Using this product time can be saved so, deadline can be met easily. If this product is developed one time and can be reused by sever

Help!!! Validate data in server (business tier) using Attribute

I want to use somthing like Attribute to validate datapublic class MyClass { [Required] [StringLength(64,MinimumLength=3)] public string name; [Required] [StringLength(10, MinimumLength = 3)] public string code; } And in the code i want to check the myClass object is valid or not using something like:MyClass myClass = new MyClass("smith","aa") if(ValidAttribute(myClass)) { //do some thing here } So, anybody can show my the way to do something like i wrote.Many thank!!!

How do i pass my datacontract into my business layer without a circular reference????

Ok, this architecture is fairly new to me, so I need a few good pointers.  I've searched the topic, but still don't have a clear understanding on what I'm missing.   I have a presentation layer, which displays my data and forms. I have a WCF service, a business layer and a dataAccess Layer I am trying to read data from on OLD!! foxpro .dbf file.  I've read all the articles on why not pass Datasets, etc so I'm trying to learn how to pass data contracts.  I have the following in my WCF [ServiceContract] public interface IService1 { [OperationContract] void SaveNDFData(string storedprocedure, ndfContractLibrary.NDFDataParam[] ndfData); <strong>[OperationContract] List<ndfContractLibrary.NDFDRawData> getRawNDFD();</strong> } I have a separate library for my dataContracts as i know later I will have several.  I'm using this as a generic List<> [Serializable] [DataContract] public class NDFDRawData { private int batchNumber; [DataMember] public int BatchNumber { get { return batchNumber; } set { batchNumber = value; } } private int sampleNumber; [DataMember] public int SampleNumber { get { return sampleNumber; } set { sampleNumber = value; } } private decimal invitroHour; [Da

Starting Data Access Layer Tutorials - Confusion on Database downloads

Hello.I have really enjoyed going through the Security Tutorials. They were well done and I think I learned a lot.I am just about to start the first Data Access Layer Tutorial. I am a little bit confused.I have MS SQL Server 2005 and MS Visual Studio 2005 on my laptop.The first tutorial says to download and use the Northwind database. But, the link in the tutorial goes to a MS page that says that the Northwind database is for SQL Server 2000 - although it will work with 2005. The page suggests that I use the AdventureWorks database with 2005. But, when I click on the link for that page it says that this database is now on CodePlex servers and gives me yet another link.I just want to use the right database for this tutorial. Can someone please explain to me what is the right process for this tutorial? Will I just be able to download and run the EXE for the Northwind database with what I have and immediately be able to start going throgh the tutorial? Or, will I need to make some adjustments since the Northwind DB is for SQL Server 2000? I just don't want to get something installed and then have to back out of it.Thanks.

VWD Express Doesn't step into the Business Layer Function



I have a solution that consists of some web projects and websites (seperate projects in one solution) When I run the main project and debug I want to step into a function that resides in another project as a business layer function and then step into another function in DAL project. I set breakpoints in both projects (DAL and BLL) but am not able to step into those functions!!!

What is the problem with vwd express, It should support such vital thing. 

VB code behind the Business Logic Layer ???


Hello. I was hoping for some general help and comments.

I went through a lot of the ASP.Net Web Forms Tutorials.

I also went though the whole "ASP.Net in 24 Hours" book by Scott Mictchell. I followed everything that went on in that book and built the final project successfully. I also used the tutorials here to better understand the whole Membership Provider/User tables setup that was going on in the book.

Next, I thought I would learn more about accessing data for ASP.Net since that is what most application do.

I went through the first Data Tutorial here. I seemed to understand what was going on just fine.

The second Data Tutorial seemed to just show a lot of VB code to build the Business Logic Layer. There was not much explanation about how to do it yourself.

I think I can keep going in the tutorials here. I downloaded the code from the second tutorial and went through it.I am guessing that the code in the second tutorial was given just to proceed with the overall project that is being built throughout the tutorial sequence.

I just wish I understood what is going on in those long lists of VB code. I can see some of what is going on. I don't know VB very well at all. So, what is the next step?

I have started working through a VB book. Will learning VB help me understand the code in that tu

What scenarios make us to create static class and static methods?



I am aware of the terminology "Static Member", "Static Class" and "Static Method"

Give some examples, What scenarios make us to use or create Static member, Static Class and Static Method?

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend