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?
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.
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
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.
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 ?
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?
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.
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.
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?
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
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(); }
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.
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)
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.
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
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.
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.
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?
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...
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.