WCF / ASMX :: Webservice Architecture In Framework 3.5 To Add Data To SQL 2005?

Apr 15, 2010

I have a webservice(Framework 3.5/VS 2008) that assembles data from 3 other webservices and puts it into SQL Server 2005. The data from these webservices is mutually exclusive. What is the recommended architecture for the same?

View 5 Replies


Similar Messages:

WCF / ASMX :: Bulk Insert Data Into Asmx Webservice?

Feb 24, 2011

I have datatable consist of 20 records and i want to bulk insert into sqlserver through the asmx webservice. Can anybody guide to me or provide Sample BusinessLogic and webservice code.

View 1 Replies

Architecture :: Entity Model Design Framework And N - Tier Architecture

Dec 25, 2010

recently i've studied on ADO.NET's Entity Model Framework and say 'wow' as ORM is one of the fevourite pattern i practice..but suddenly i've come to an ambiguous situation when i'm going to start. i usually follow the following 3-tier architecture..

1. UI Layer
2. BLL - business logic layer
3. DAL - Data Access Layer
a. DTO / DAO
b. Gateway (contains the sql query/stored procedure and connection with DB)

now when i'm going to use the Entity Model Design,where the DBML/ .edmx File should be placed? Because many a times i'm using the DBML file as DTO because of the mapped objects.. in the same time, sometimes DBML ( .edmx file in .NET 4.0) contains CRUD methods and stored procedured method as well as methods with different selection operations,- which should be in Gateway. so where the .edmx file should be placed !?!! IN DTO namespace !? or in Gateway namespace!

moreover sometimes there is no need for the BLL which breaks the rules of inter-layer-communication (UI > BLL > DAL.Gateway)! what makes me confuse is, what should be the ideal n-tier architecture when i'll use the ADO.NET Entity Model Design Framework

View 4 Replies

WCF / ASMX :: Read The Set Of Data From Webservice?

Jun 3, 2010

In my project I have have a query in my Webservice

cmd=new SqlCommand("Select * From Record ;",conn);
conn.Open();
DataReader reader=cmd.ExecuteQuery();

now I want to return this Extracted data which may contain various rows and column

How can it be sent.???

One way is to Send it as XML Document But I don't know how to do this i.e. How to convert this set of record in to XML Document. and then How to retrieve values from this Document in a GridView at the requesting side.

View 2 Replies

WCF / ASMX :: Return XML Data With WebService?

Jul 10, 2010

i have a data library dll and first is it possible to use it in webservice forexample i call it as using DataLibrary; then in web method i will use it like

public boolean MethodName(int a)
{
if(DataLibrary.Method(a))
return true;
else
return false;
}

and also i have to tell my all data connections are in DataLibrary.dll

my second question is i will use webservice to communucate with flash i will send flash a DataSet but flash cant read DataSet so i have give it as XML right?

so how could i change my following method which returns dataset to return xml ?

[Code]....

View 6 Replies

WCF / ASMX :: Passing Variable From Dropdownlist.selectedvalue To Asmx Webservice

Nov 10, 2010

On my page I have a dropdown for country.

On my asmx service I want to get the value of the dropdownlist to filter the next input which will be state/providence.

My code on the asmx:

[Code]....

I want to add another clause to the WHERE statement to restrict Country = @Country so I will need to get that value to the web service.

View 2 Replies

WCF / ASMX :: Import Table Data Using Webservice?

Oct 1, 2010

I'm starting using web services in .net , I'd like to know how to achieve this:

I need to import table data into a database, currently what we do is uploading via ftp the text files, and then running a process in php in the webserver.

Could this be automated by sending those text files (or xml, or whatever format is necessary) to a webservice as an argument, and that the webservice handles the insert and validating process of the data?

View 1 Replies

Architecture :: Data Binding To Entity Framework Classes?

Feb 1, 2011

I am using the ADO.NET Entity Framework for loading data from the database. The classes are directly mapped to database tables in the database. The problem is that these classes are not optimal for binding to the UI elements. As a result of this I have some custom entities which are populated at the service layer and returned. It is these custom entities (classes) to which I bind the UI elements. My questions on this are1. Is populating these entities at the service layer the most appropriate way to do this. I personally do not think so because if we introduce some additional UI elements which need different entities then I have to modify the service layer again.2. What is the best approach/pattern to get this done.

View 2 Replies

Architecture :: How To Upload Data To Sql Server 2005 From Client PC

Mar 22, 2010

The Dumps data are in the Excel file. Now I want o upload the data to sql server 2005(which are in web server) from client pc (from browser). What will be the best way to do so?

I can know how to upload data from excel to sql server 2005 if both are in the same computer.

View 5 Replies

WCF / ASMX :: Webservice To Import Data From Client Side

Apr 28, 2010

I want to build a webservice that has to get some data as parameter from the client application. the data from the client side are records from there database. my websercie has to send then these data to a soap server through 'HttpWebRequest'. Can i get the data as Datatable? and then send as stream to the soap server? Or maybe there is a better easier ways?

View 2 Replies

WCF / ASMX :: Return A Data Record From A Webservice (wsdl)?

Aug 23, 2010

vs2010, .NET 4.0I have a webmethod which I want to return a data record (for example: name, surename, address, age, zip etc)I wonder how to accomplish this. I think the solution is about creating an object which contains all the records serialized. And then the webmethod returns this serialized object. I'm not 100% sure how to accomplish this, if some of you good provide me with some tips, tutorial or link to an article explaining it, that would be great

View 1 Replies

Architecture :: Ado.net Entity Framework - Query - Return Correct Data

May 26, 2010

I just tring to a complex (for me) with ado.net entity framework this is the structure: In practice it is a sort of group purchasing (Buyers) For each group of purchase (Buyer) should have the opportunity 'to select all products of the brands indicated in buyer I'm doing function to return correct data like this:

public List<Product> GetProductsByBuyer(int vBuyerId)
{
Buyersctx.Products.MergeOption = MergeOption.NoTracking;
return (from lProduct in Buyersctx.Products.Include("Brand").Include("Buyers")
where select lProduct).ToList();
}

View 2 Replies

Forms Data Controls :: Convert DataTable To DataView VS 2005 (.net Framework 2.0)?

May 4, 2010

I am doing GridView Sorting without ObjectDataSource. For this requirement I need to convert DataTable to DataView, I know I can do that in VS 2008 but How can I do this in VS 2005.

View 20 Replies

WCF / ASMX :: Using Static Hashtable In Webservice For Sharing Common Data Among Different Users

Nov 26, 2010

We are using static hashtable in webservice for sharing common data among different users. Is it safe? Is there any better way?

View 1 Replies

WCF / ASMX :: How To Execute WebService Asmx Link From Default.aspx Page Link Using HTTPRequest And HTTPResponse

Nov 3, 2010

I have spent a couple of days on this one. I have an ASP.NET website that has Linkbuttons on

the Default.aspx page.. I added a WebService to the Website because later on the WebService will

subscribe to a Provider(Feed) of News, Sports and Weather and things like that. So when a Linkbutton

on the Default.aspx page is clicked it will connect to the link in the WebService which will load the News,

Sports or Weather onto the Default.aspx web page.

The problem is I can't get the LinkButton to execute the Link in the WebService. The link will call the page up

to where you see all of the Web References. But then if you want to execute one of those references you

have to click its link and the Invoke button that will follow. My questioh is how can the link on my Default.aspx

page execute the link in the WebService. Now I changed the LinkButton into an <a href> but I still can't execute

the link in the WebServices. I always use www.Microsoft.com as the link when testing and I wasn't sure about the return type

so I put "void" for an HTTPRequest, so below is the link from the Default.aspx web page and below that is he asmx file:

[code]....

View 2 Replies

VS 2005 - Timeout Calling Webservice

Feb 15, 2012

I have an intranet application that is calling a webservice (code below). The webservice calls a stored procedure in q sql server 2005 that again does an openquery on a db2 (AS400) machine. The stored procedure is returning a temp table. On the call to the webservice I am getting a time out. At this point if time out the web service is still running and I can also see the query is in the program stack on the db2 machine. The query itself can take up to 20-30 minutes as it is reading 3 mill+ records. If I call the web service directly I get the result returned.

Code:
Dim getOrderDetail As New localhost.OrderDetail
myDataTable = getOrderDetail.GetOrderDetailRecords_DataTable(myUserId)

View 5 Replies

.NET Architecture And What Is .NET Framework

Sep 25, 2010

Could somebody tell me what is the architecture of the .NET, and what is .NET framework and what are the very important things that I really need to learn? On googling I am not getting any satisfactory answers and I am getting more confused also.

View 1 Replies

MVC :: Difference B/w Mvc Architecture And Framework?

Oct 7, 2010

i create 3folder in solution explorar,model view ,conroller in view i inclde .aspx formsin model class related to data base and in controller properties .so am i follwing mvc architacture .so what is diffrence b/w mvc architacture and mvc framework

View 1 Replies

Wcf - SOA Architecture For .NET With Entity Framework

Apr 1, 2011

I am redesigning a Solution's Architecture to implement SOA.

After doing the design changes I have come up with:

MySolution.Client.MyProject.Web ...... //ASP.NET WebSite
MySolution.Client.MyProject.Proxy .... //Service Proxy C# Library Project *[1]
MySolution.Service ................... //Service.cs for Service.svc is here
MySolution.Service.DataContract ...... //IService.cs for Service.cs is here *[2] [code]....

This project contains IService and Request/Response Classes

All methods in Service.cs takes the Request classes as input and return Response classes as output

Therefore this project is referenced by the 2 Client Projects(Web and Proxy), as it contains the IService and all of the Request/Response classes that will be required to communicate with Service.cs

*[3]MySolution.Model: This project contains the .edmx that is the Data Model of Entity Framework and some custom classes that are used in the project.

PROBLEM: Because I only use Request/Response classes to communicate between service and client, The MySolution.Service.DataContract project is only used by Service.cs and Repository.cs

And due to that all responses that Repository generates i have to map them to the properties of its respective response class (which make both the original returned entity, and the response class almost identical). But i am OKAY with it ...

e.g: GetCustomer() in Repository.cs method is called by Service.cs

GetCustomer() method in repository performs the LINQ query and return a "Customer" object

Service.cs then maps all the properties of "Customer" object to the "CustomerResponse" object

Service.cs then returns the "CustomerResponse" to the caller.

in this case most of the properties will repeat in both classes, if there is solution to this, its good, otherwise, I am fine with it.However, when Repository.cs's method GetCustomers() (Notice its not GetCustomer()) is called, it will return List of Customer object, and mapping this for return purpose would mean a "for loop" that iterates the collection and do the mapping ... this is NOT OKAY ...

is there any better way of doing this, considering I do not want to return "Customer" object without "CustomerResponse" as first of all it violates the SOA architecture, and secondly I don't want my Client Projects to have any reference to the Model or Repository projects.

View 3 Replies

WCF / ASMX :: PHP Webservice?

Apr 24, 2010

I am using PHP web service in dot net [URL]I set the name of web service as Test but when I am trying to access object test I was not able to use that, is there is any other method to use PHP webservice.

View 1 Replies

Use A WCF Or An ASMX Webservice?

Jul 9, 2010

I was looking for an asp.net webservice that uses .net 4.0 but everytime I choose 4.0 the webservice choice goes away.Someone suggested to me that maybe they(MS) want you to use WCF instead. I don't know much about it but he said they are like webservices but better. So anyone got a comparisons guide?

View 3 Replies

WCF / ASMX :: How To Use Webservice

Jan 28, 2011

Any body knows How to use webservice ? using Get & Post method...

View 3 Replies

Architecture :: Framework For A ERP Web Based Application

Mar 31, 2010

I am designing frameWork for an ERP application ijust have some quries regarding it

Some standards have to be set for this project ,need some help for it.

1)folder structure of the project for frame work 4.0

2)Layering should be done like(3 tier,n tier) if i want to Go for more than 3 layers what could be the other layers except BAL,DAL,Presentation.

3)should all the images be called from css,or some images can be called from the page it self.

4)what benchmarks should be set while writing Stored procs,to make uniformity and increase performance.

5)what securtiy messaures should be taken so that application remains free for intruders.

View 3 Replies

Architecture :: Advantage Of Using MVC And/or Entity Framework

Oct 2, 2010

I am new to Entity frameworks-EF. As, EF is built on top of ADO.NET...If so, will there be any performance issue when we use it?Same way MVC also targets Test Driven , rapid application development only ..What speciality does it add for end-users?As per my understanding ASP.Net 2.0 itself is powerful without MVC and/or EF...

View 7 Replies

Architecture :: Generic Framework Package?

Dec 22, 2010

I have worked on larger projects in the past, and am working independently on a new project without the aid of the base code I have used in the past. Is there a recommended open source framework that contains the basic essentials (error handling, security, general structure) that can help me jump-start the development process. I will be using VS2010/Sql Server 2008/Windows Server 2008.

View 2 Replies







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