Architecture :: Web Application Connecting To Multiple Databases?
Sep 17, 2010
I am supposed to develop an enterprise-class ASP.NET Web Application that connects to multiple databases. For example when the web form loads, I should populate different ASP.NET controls (GridView, DataPager, TextBox, DropdownList etc) from multiple databases (SQL Server, Oracle, DB2, SAP Server etc) and also, edit the data in the controls and save the data to the respective databases on button submit.
Should I use Web Service or WCF for data integration, if so is there a limit on the size of the data?
What should be the architecture considering the application should be scalable and easy to maintain?
I am developing a web application with back end as Oracle. I call the procedures from web application when ever some update, create or delete for the records needs to be performed. How to maintain the connection in these scenarios.
Can I open the connection and maintain it through out the application till user logs out?
My Application uses two SQL databses, one for membership/roles (ASPNETDB.MDF) the other for my data. When deploying to a server do I have to use two connection strings, one for each database? I am using the publish to provider wizard with VWD 2008 to replicate the databases on Sqlserver 2008 (Windows server 2008 R2). I have my data connection working fine, I am just trying to get mebership and roles working.
I need to develop an application, which will get records (orders) from one application and process them. The updates to this records (order updates) will be sent back to the source application for end customer reference. I'm planning to achieve this data synchronization at the database level using triggers and stored procedures to insert database between the 2 databases.
But, the issue is I have to deploy this application in 3 different customer sites and I have to change the database names (cannot use the same database name) in each deployment manually. Because of this deployment issue, I was thinking of handling this within the asp.net application where I can store the db name in the database and then build the query within the application, but I dont want to do it as building queries like that doesnt look very professional.
I already have an existing sdf file that is used in a windows application by looking at the current programs folder to find it. I want to use this same database (a copy of it) on an ASP .Net website so won't be hosted in a sql server anywhere want's to be accessed directly, is this possible?
In my asp.net application im using Oracle client. In the connection string, we specify the 3 basic attributes: data source, User Id, and Password. We are using connection pooling. Our data resides in 2 different Oracle schemas. Most of the requests are for data from both Schema1 and Schema2.
Is it possible that the connections are implicitly tied to a schema1 or schema2?
I am new to the asp.net, I am going to create a website which needs to talk to oracle database(i only need get the data only) which is in client place.
I want to know what do i need to do this (what are the requirements)
What i have is Client IP, DB name, Username and Password.
i want to develop a data access layer ,it can support multiple database like oracle ,Mssqlserver and Mysql using enterprise library and C#.net 3.5 based on database connection
The problem i have would be im getting - 'System.Data.SqlClient.SqlException: Login failed for user 'discountb1'.' error message. my connection string in ASP was the following
I've been developing a asp.net/c# web application that uses .net routing with Visual Studio 2008. The project is setup to use http://localhost:17315 as the server path. I'm trying to figure out a way for a co-worker to connect to my local project from their system. When I setup the project as a virtual directory in IIS (5.1) the .net routing doesn't work correctly and I get a 404 error (http://localhost/home).Is there anyway for a user on our local network to connect to my application remotely with my current configuration? I know they can't connect to the Visual Studio Development Server, but I would think they should be able to connect if the application is setup in IIS. Maybe IIS6+ is needed for this?
I have all my tables and queries in online DB ie., i have created all my tables and queries in online using third party site [URL] Now i want to make connect my application (which is in my system) with that database
I am trying to design my logic to do this but I want to create a dataSet which will have records from several databases, The records all have the same layout.
I am reagin the connection string paths from a table in a database.
I am asking for your help in trying figure out my logic.
Should I use the connectionString builder in conjunction with a loop to Connect, read a record into a dataset Until therer are no more records to be read from my databse table with the database name/paths tables ?
Here is my beginning code which deals with one database:
I had another thread on this problem but I wanted to start this one so no one had to look at the code I posted in the other thread. I have a successful connection but want to display data from the SQL database on my website in my Windows form application. Here's the code I have so far. Used some of the ADONET Tutorial1 here. The table Ray Rover Activation has a number of different columns but to start out I just wanted to see if I could display data for the EmailAddress column.
Code:
[code]....
If I comment out the Sub DoStuff I don't get any errors but neither is anything displayed other than the messagebox message. If I don't comment out DoStuff then I get an error, "Incorrect syntax near the keyword 'FROM'". Maybe someone could enlighten me some on what I need to do get the data in the column EmailAddress to display.
While working with LINQ to ENTITIES I see that there is only a way to use stored procedure that is returning one entity only, or a view that is a join of two entities.
But what if I need in ASPX page to get two tables that there is NO connection between them, no join can be done between them at all.
I have one Stored Procedure that return the two tables, but entities don't support this right now.
I can split them to two Stored Procedure and call each of them separately.
I am using Visual Studio 2008, I am new bie to create windows mobile application. I haven't installed Windows Mobile 6 SDK. I have started with built-in SDK and Emulators of VS 2008..
My question is, Can i create windows mobile application without connecting device ( Mobile or Pocket PC )?
I am developing an intranet application that needs to authenticate against a global catalog server (containing about 14 domains). What would I use for the connection string?
I need to auto update application like in wordpress, Application must check if new updates are available, download this updates and install.But I don't know how to install application. Because if some files in bin directory are updated application is restarted.Is it possible to create ASP.NET web application which will be auto updatable?now we have a new technologies, could u please suggest me any kind of soultion for the above problem. here i am enclosing my email idsunnyb4uu@hotmail.com
I m sure this question has been asked before. I have a web application hosted underhttp://localhost/abc. which is mapped to c:inetputwwwrootabc folder. I have APP_Code, App_LocalResources, BIN and other folders under abc folder. Everything is great. Now I want to create another application or sub application http://localhost/def. Both abc and def apps need to use some common classes and resources. Whats the best way to do it. I dont need to create a separate application for def. All i want is the url http://localhost/def.
I have been creating my BLL and DAL with in the same project as my UI. These have been logical tiers in their own folder with in the same project, that's with in the same solution. I want to try to create a solution that is more like a truly multi tiered app.
I've heard people talk about using a separate projects for their DAL and BLL. My understanding is that these would be separate dlls that would contain the appropriate code for each of the these tiers. I have a few questions regarding this.
Is this a good way to do this? It seems like a logical approach. It also seems like the next step in me moving towards an architecture that's truly tiered. Should I do this differently?
Should the projects for the BLL and the DAL use the same namespace? I think I read that some people use a namespace for each of these that indicates what they are, such as BLL and DAL.
I have to update multiple row and two column of each row.
I have try to Update with case statement but after I perform that statement it blank out every other column that doesn't fall into the criteria of the update statement.
My table structure is like this;
table1 col1 row1 11 row2 22
I want to update row1 and row2 of their col1 in one single sql , how do i do that?
