web service

Question

User-1986008217 posted

Hi;

I want to make web service for n tier web site.I used business tier and datalayer.
I want to make asmx for two layer.I make web service and copied to functions under [webmethods] in new web service.
But my all functions connect to data layer.Like that

[WebMethod]
        public DataSet Check(string userName, string password)
        {
            

            string query = "SELECT * FROM Newuser WHERE Address = @Username AND Pass = @Password";
             
            MySqlCommand command = new MySqlCommand(query);
            command.Parameters.Add(new MySqlParameter("@Username", userName));
            command.Parameters.Add(new MySqlParameter("@Password", password));
            
            return DATALAYER.DataTier.Default.SelectCommandParameterized(query, command);
 
        }

 I added project DATALAYER to same solution.After that I added reference datalayer.dll. But vs2012 dont allow this.It underline DATALAYER.And error:

THE name "DATALAYER " does not exist in the current context.

How to make web services business layer ?
Any opinion?

Thanks in advance 

Answer 1

User-861818263 posted

Check

http://social.msdn.microsoft.com/Forums/en-US/asmxandxml/thread/d7e80d9f-b6ad-4086-888a-0eb43a81db23/

Answer 2

User260886948 posted

Hi,

I see that you want to use Web Services in a 3-tier architecture. In logical design there is standard approach: UI layer-> BL layer -> DAL.

For how to create this architecture, there are many good tutorials which you can refer to:
http://www.codeproject.com/Articles/11128/3-tier-architecture-in-C .

http://www.codeproject.com/Articles/10941/Three-Tier-Code-Generator-For-ASP-NET .

http://dotnetbloc.blogspot.com/2013/02/create-web-application-in-aspnet-in-3.html .

http://www.dotnetfunda.com/articles/article71.aspx .

Hope it can help you.

Best Regards,
Amy Peng