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 RepliesI 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 Repliesrecently 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 ?
[Code]....
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.
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.
View 2 RepliesThe 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?
View 2 Repliesvs2010, .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 RepliesI 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.
View 20 RepliesWe are using static hashtable in webservice for sharing common data among different users. Is it safe? Is there any better way?
View 1 RepliesI 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]....
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.
View 1 Repliesi 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 RepliesI 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.
View 1 RepliesI 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 RepliesAny body knows How to use webservice ? using Get & Post method...
View 3 RepliesI 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.
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 RepliesI 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