CMS/E-commerce .net Project : One Database Or Multiple Databases?
Mar 31, 2010
I'm currently working on an C#/ASP.NET project that will host several differents e-commerce websites, all running in the same application.I use LinqToSql (moving to PLINQO soon) to access my database. The database contains both informations on the website structure (pages, ...) and the products/orders/users data.
My question is, should I use only one database for all the websites, or sould I create a new database (same model) for every new website?I'm now using a single database (with SiteIDs in some tables) but I have a big security concern, I can't just backup/restore the database for ONE website if something goes wrong (e.g. somebody erase all the products on ONE website) and it's an important requirment of the application.
So I was wondering what are the good practices in that case? Is there big cons if splitting dbs?(I would have to make changes to several database instead of one in case of structural changes, but i guess i can make a db version/update system).How the existing CRMs are dealing with that?Is it a performance problem if a database server host a lot of different DataBases? A complex backup/restore tool would be better?
Subquestion:To make a website replication easy, I can also split the pure CMS data (Pages, Texts, ...) in one DB and the e-commerce data (products/categories/orders in another). It can be achieved by some select/insert functions but it would be easier by just copying a database of course.
View 1 Replies
Similar Messages:
May 19, 2012
I am making project on hospital management which will contain different databases for different hospitals. how can i manage this thing with single asp.net project?
View 4 Replies
Feb 13, 2010
I have a project using vb.net with mySql and mySql.Data.dll as a link to the database. Now when I test my website from local computer and with live server connection string all works fine. The thing is, when I upload my files to the server, it gives me an error Object reference not set to an instance of an object.I have copied the mySql.data.dll file to the bin folder of my domain and the query that gives the error is a basic insert statement that works from the local machine to the live database.
View 1 Replies
Oct 6, 2010
I'm working in an environment where a single web application (running in a web-farm) dynamically connects to different SQL Server databases (possibly on different servers) based on user selection (this part is non-negotiable, unless you can gift me $1,000,000 and/or some kind of time altering device).
I'd like to cache some of the commonly used data from the database(s) in the application, such as "settings", and am looking for a best practice to use with the SqlCacheDependency class or a related database cache dependent solution (not opposed to a custom implementation of SQL notification or polling; notification is preferred over polling).
So far, I'm thinking of using a collection of SqlCacheDependency objects (one for each database) that can be referenced by connection string name or related key. So when the connection is changed to a different database, the cache can be requested/populated by a key of <databasekey>+<datakey> and use the appropriate SqlCacheDependency object (probably handled by a cache-managing wrapper).Or is it just better to take the hit and always go to the database?
View 2 Replies
Aug 6, 2010
Well I Am Working On A Client Project Who Was Earlier Using A Software Developed On Foxpro database And Now I Am Developing Advanced Reporting Based On Same Data Of Existing Database
I Am Prohibited To Create New Database, I Have To Use Existing Database Now Problem is That There Is A Report Which Require data from multiple database
database are related Like This
Database (a) 1 Column is Common in Common In Database (b)
database(b) 1 column is common in database (c)
like that
what i am doing is that, I First Filled A Dataset With Required Value Then I loped This Dataset Row For Value On Which I Have To Get Data From Another Database Again I Stored new data in another dataset and After Looping, I Merged It With Previous One.
View 1 Replies
Jul 6, 2010
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
View 1 Replies
Mar 7, 2011
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:
[Code]....
View 2 Replies
Dec 13, 2010
There is one oracle 11g server, I want to create connection from my .Net project. tell me the steps which I need to follow for create connection.
View 2 Replies
Jan 21, 2011
To start, I am a new web developer. I have been writing C# for about a year, but just recently learning web development. I wrote an application that connects to a MySql database and when I run it on my localhost it wokrs great! I created a ubuntu server on amazon ec2 and it is hosting my MySql server. It is up and running just fine. I created a windows 2008 server instance on amazon ec2 to host my asp.net project. I published my project to my windows server and I went to my public IP address and my site was there! it was so easy...
However, when I went to login, I recieved this error: Could not load file or assembly 'MySql.Data, Version=6.3.5.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d' or one of its dependencies. The system cannot find the file specified. I made sure the correct connector was installed on ym server. I have the most recent mysql connector installed. I do not know how the publish actually works. I saw some forum posts that said maybe I was missing DLLs from my bin directory but I cannot even find my bin directory for my project on the server. I also saw some posts about changing the web config file, but that was gibberish to me at this level.
View 3 Replies
Feb 28, 2011
I have a vs2008 Website project(it was converted from vs2005), when i right click the Website node in the solution and open the property page, i select the references link, then click add reference to Oracle.DataAccess.dll(11g, 64bits), Version=2.112.2.0 in the website BIN directory, it doesn't work, i don't see the Oracle.DataAccess.dll is added, Can you give me any advice why the website project can not add the Oracle.DataAccess.dll ? And I can add rOracle.DataAccess.dll to my other Web Application project, what difference between Website project and Web applicatoin project caused the issue? Since i can not add the Oracle.DataAccess.dll , when i compile, it gave the error:
Could not load file or assembly 'Oracle.DataAccess, Version=2.112.2.0, Culture=neutral, PublicKeyToken=89b483f429c47342' or one of its dependencies. An attempt was made to load a program with an incorrect format.
View 4 Replies
Oct 7, 2010
I'm going to write an ASP.NET MVC 2 application using Domain Driven Design. I'm trying to figure out how to separate the Admin from the store front. I could create 2 MVC projects, but regarding the services for them, should they be in separate projects as well or could I use the CatalogManager, for example, for both, Admin and the store front, and mix up all the services?Currently I have a class library for each part of my domain (services, infrastructure, model, etc.)
View 1 Replies
Mar 26, 2010
protected void Button3_Click(object sender, EventArgs e)
{
//Create a connection to the database
MySqlConnection conn = new MySqlConnection("Database=kid07025;Data Source=195.178.228.254;User Id=kid07025;Password=********");
//open the connection
conn.Open();
//MySQL Query which updates the row where Anvandarnamn = Anvandarnamn (recieved from a cookie)
MySqlCommand cmd = new MySqlCommand("UPDATE personer SET Information=?Information,Fnamn=?Fnamn,Enamn=?Enamn,Personnr=?Personnr,Adress=?Adress,Postnr=?Postnr,Ort=?Ort WHERE Anvandarnamn=?Anvandarnamn", conn);
// Update with new text
cmd.Parameters.AddWithValue("?Anvandarnamn", Request.Cookies["Anvandarnamn"].Value);
cmd.Parameters.AddWithValue("?Information", TextBox1.Text);
cmd.Parameters.AddWithValue("?Fnamn", TextBox2.Text);
cmd.Parameters.AddWithValue("?Enamn", TextBox3.Text);
cmd.Parameters.AddWithValue("?Personnr",TextBox4.Text);
cmd.Parameters.AddWithValue("?Adress", TextBox5.Text);
cmd.Parameters.AddWithValue("?Postnr", TextBox6.Text);
cmd.Parameters.AddWithValue("?Ort", TextBox7.Text);
cmd.ExecuteReader();
conn.Close();
RefreshProfile();
}
I don't know what I am doing wrong here, but the database doesn't get updated when I press the button.
I use VS 2010, ASP.NET
View 3 Replies
Oct 26, 2010
I worked on an online store based . In this store i have a category for which there are almost 2000 products. So every time when there is some change in the price, it is very difficult to update the products with new price, descriptions, features etc.The manufacturer of this product is providing web services which can be linked with store owner's website who is selling their products.o is it possible to integrate e-commerce website with webservices API that are being provided by manufacturer ?
View 1 Replies
Mar 9, 2010
Im Searching for a tutorual to make a list of the most bought products on my e-commerce site. (toplist)
View 2 Replies
Mar 5, 2010
I have worked mostly with PHP when creating web sites driven by dynamic content. However I am wanting to start writting more applications in ASP. So I have a copule of questions that I can't seem to find the exact answers I need.1) I'll be creating a website for a company and then later be adding an online ordering system for them - would I best be served by writting the entire site in MVC2 since I will be getting into an online ordering system?2) Does it make sense to create my own shopping cart system - or are there free packages out there in ASP.NET that I should be utilizing instead of rolling my own? I3)I am currently working in Visual Studio 2010 Beta 2 - this is using the .NET 4.0 framework - I thought it better to use this instead of my older Visual Studio 2005 Professional - if I can't afford the full package of VS 2010 once its released - will theexpress editions support all I need? 4)If I am building in 2010 will I have a problem getting the site hosted since that framework is still in Beta? And can you suggest a good web host to use for .NET hosting - I usually work with GoDaddy for all my hosting needs - but I'm not sure if anyonehas experience in how quickly they will update to the newest frameworks etc , or if I should be hosting somewhere else.
View 2 Replies
Feb 27, 2010
I'm working with Oracle database and I want to improve performance of my website.I read about caching. So is it possible to implement caching (SQL Server Database Dependency) with oracle?
View 2 Replies
Jun 21, 2010
We are working on an e-commerse application, we have requirement to set discount (10%) on purchase on a specific weekday. Ex. If any transaction made on Wednesday, it will get 10% discount on purchase amount.
Since the website trafic scatered to different geographical area the time should be not be bound to a specific location.
One of the approach which I thought, was to get the IP address of client then use some tool to find out the country and GMT (UTC) time. And based on that decide the exact weekday to provide discount.
But some of the issue with this approach are:
- Which tool to use to find out the IP address
- The tool like IP2Location are paid. Is there any free tool available? etc.
View 8 Replies
Jan 24, 2016
I am working on E-Commerce project based on Asp.Net. I need to implement Security in my Project. Which type of Security should i apply that is open source and in-build.
View 1 Replies
Feb 7, 2011
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?
View 4 Replies
Feb 28, 2011
I have two e-commerce sites. One was built using ASP .net technology and the other one was built using open source codes.
Now I would like to allow shared shopping cart between the two sites. The customer will be able to add product from either site to the same shopping cart and check out.
Has anyone done this type of project before? It seems that there isn't any easy solution -- i.e. we would have to build a new shopping cart from group up for both sites.
View 1 Replies
Aug 11, 2010
In my web application, I have 2 totally different databases - one that's being used mostly by a CMS from which we'd like to get page information on non CMS pages on the same website, & one that contains totally different data. Is it possible to use Spring.NET's Open Session In View module with multiple session factories for both of those databases, so in this case I have 2 objects defined in spring.config of type Spring.Data.NHibernate.LocalSessionFactoryObject?
View 1 Replies
Nov 10, 2010
I have an application which connect to oracle db.
I have two database hitting functions.
One is adding Userdetails(Fn Name : AddUserDtls) and another one adding address details(Fn name : AddAddresDtls) based on UserName which will get added after execution of first method ie AddUserDtls.
Problem I am facing is :
I have a single transaction and in that I have all the methods.
After the execution of first method,with out commiting i will go to second method.
and if any error occurs in second method.
I will rollback everything including the changes made by first method also.
Here one issue is there.
Since I am not committing the changes made by first method,
While I am executing the second method I am getting error that 'No user Name exists'
I understood that if we commit the transaction before the second method starts ,it will solve the issue.
But then it creates another problem.If some problem araise in the second method,then I cannot rollback the changes made by first method since it aleready commited.
View 1 Replies
Dec 15, 2010
In following code I am binding two parameter by name. Program compile successfully but output isn't coming.
cmd = new OracleCommand("select * from books where book_id=:bid and title=:rat", conn);
OracleParameter op = new OracleParameter();
View 2 Replies
Feb 2, 2010
I am coding in ASP.NET C#. I have Microsoft Dynamics GP hosted at a server and my database hosted at another server. I would like the GP database take value from some table there and synchronise it with my database. Which is the best alternative? Data transmission Service(DTS)?
View 1 Replies
Aug 21, 2010
I have got a new assignment for developping an e-commerce website. I need to accept online payment via all the common cards (Visa, MasterCard, etc). But am confuded about how I should implement it. I want to add direct payment with credit card to the website without passing by paypal.
P.S.: The website is targeted for UK customers only. Technology:ASP.NET, C#
View 1 Replies
