Sql Server - How To Create New Database Programmatically In MVC Application
Jan 28, 2011
I have worked on a timesheet application application in MVC 2 for internal use in our company. Now other small companies have showed interest in the application. I hadn't considered this use of the application, but it got me interested in what it might imply.
I believe I could make it work for several clients by modifying the database (Sql Server accessed by Entity Framework model). But I have read some people advocating multiple databases (one for each client).
Intuitively, this feels like a good idea, since I wouldn't risk having the data of various clients mixed up in the same database (which shouldn't happen of course, but what if it did...). But how would a multiple database solution be implemented specifically?
I.e. with a single database I could just have a client register and all the data needed would be added by the application the same way it is now when there's just one client (my own company).
But with a multiple database solution, how would I create a new database programmatically when a user registers? I have done all database stuff using Linq to Sql, and I am not very familiar with regular SQL programming...
how this could be done (as well as input on whether it is a good idea or if a single database would be better for some reason).
EDIT:
I have also seen discussions about the single database alternative, suggesting that you would then add ClientId to each table... But wouldn't that be hard to maintain in the code? I would have to add "where" conditions to a lot of linq queries I assume... And I assume having a ClientId on each table would mean that each table would have need to have a many to one relationship to the Client table? Wouldn't that be a very complex database structure? As it is right now (without the Client table) I have the following tables (1 -> * designates one to many relationship):
Customer 1 -> * Project 1 -> * Task 1 -> * TimeSegment 1 -> * Employee
Also, Customer has a one to many relationship directly with TimeSegment, for convenience to simplify some queries.
This has worked very well so far. Wouldn't it be possible to simply have a Client table (or UserCompany or whatever one might call it) with a one to many relationship with Customer table? Wouldn't the data integrity be sufficient for the other tables since the rest is handled by the relationships?
View 2 Replies
Similar Messages:
Oct 25, 2010
How to create Database from .bak file in asp.net c#
and the new database should be created with new database name,user id and password
View 4 Replies
Jun 19, 2012
Cannot open backup device BACKUP DATABASE is terminating abnormally.i need to create database back from the web application but i get the above error
BACKUP DATABASE DB1 TO DISK='SERVERcPbackupDB1_19062012.bak' WITH FORMAT
View 1 Replies
Feb 6, 2010
implementing login control programmatically using sql server 2005. can anyone give me good web reference about the topic? i am new to this development.
development tool i am using:
>visual studio 2008
> sql server management studio 2005
>windows 7 ultimate(32 bit)
View 2 Replies
Apr 1, 2011
What I want to do is to store new article and for each article choose a category..
I have 3 tables for example :
1. Article table : ArticleID - int , Article - nvarchar(max) .......
2. Categories table : CategoryID - int , CategoryName - nvarchar(150)
3. Article_Categories : ArticleCategoryID - int , ArticleID - int , CategoryID - int (And I set up relation in this table...)
I can store data into tables 1 and 2 that is working fine.. But I stuck with Table 3.
So far my code looks like this :
protected void Button1_Click(object sender, EventArgs e) //Add new Category (working fine)
{
string connectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
string insertSql = "INSERT INTO Categories(catname) VALUES(@catname)";
[code]....
View 9 Replies
Mar 1, 2011
how I can correct an error. I've built the MVCMusicStore tutorial here:
http://mike-ciccone.com/Store/
The first time I visit the site and attempt a database connection I get this error:
Exception Details: System.Data.SqlClient.SqlException: CREATE DATABASE permission denied in database 'master'.
But when I refresh, it all works fine. I'm at a bit of a loss. I don't believe I'm attempting to create a database, but I realise that the error may not really have anything to do with that. This is hosted at GoDaddy shared hosting. The database was created and I used an SQL script to create the tables initially and populate the data. My connection string works as I can pull data from the database, but I do have
a feeling it will be a web.config setting that will correct this.
View 3 Replies
Jan 3, 2011
I have created a setup application and i want to create my application as an installer application.
I did for testing and while running the setup file this give me the final response is "The installer was interrupted before setup1 could be completed. You need to restart the installer to try again".
View 1 Replies
Jul 28, 2010
I have a mdf database in my computer. And I have sql management studio 2005 installed. I would like to mange the mdf database with this program and I do not know how.
View 3 Replies
Mar 30, 2011
When I created table on the shared SQL server on hosting server using management studio, I right click mouse on the table, it pops up create table. However, the table schema is my user name but not dbo. I wnat to create table with dbo schema.
View 2 Replies
Jan 12, 2011
If i wanted to communucate from two application server to one SqlServer,what are the drawbacks if i implemented a senario like this, at the same time wat are the advantages.
View 5 Replies
Jan 20, 2011
I want to create password in single database for example when i attach My database abc.mdf or open that database then it ask me password. as like access database password..
View 3 Replies
Dec 8, 2010
I want to be able to somehow get reports out of my Sql Server database in an MVC application. I could have developed a way to do that using xml and then transform it to fo and rendered it via an fo processor to pdf. But that would require being able to have the fo processor installed on the web server, and I'm using a web host, so that's probably not going to work.
So I've seen Reporting Services mentioned here and there. Does that include the possibility to create pdfs? And if so, how do you use it in an MVC application? I tried before to mix webforms into MVC application (if that's necessary as I've seen implied) but couldn't make it work. The routing didn't seem to recognize the web form page...
Or is there any other easier way to create pdf reports from Sql Server data? I should also mention that I only use Linq (and the Entity Framework) to access data, so hopefully there is a solution that doesn't require me to know Sql stored procedures etc
View 1 Replies
Aug 25, 2010
I created the web application using asp.net 2.0, c# and sql server 2005sometimes i am getting the following error,Message: Unable to validate data.Source: System.Web
TargetSite: Byte[] GetDecodedData(Byte[], Byte[], Int32, Int32, Int32 ByRef)
StackTrace: at System.Web.Configuration.MachineKeySection.GetDecodedData(Byte[] buf, Byte[] modifier, Int32 start, Int32 length, Int32& dataLength)
at System.Web.UI.ObjectStateFormatter.Deserialize(String inputString)
View 3 Replies
Sep 11, 2010
I want to create a server because I have a fair internet speed and fair computer on the house not being used. The structure is good.The issue is, I don't know how to create the server, if I have to use Microsoft Server or if I can use an XP system.What programs do I need to install?And, furthermore, I need to know how to do everything.
View 9 Replies
Dec 2, 2010
In your opinion, what's the best way to create the server side to a pure Javascript application with ASP.NET? WCF rendering JSON? IHttpHandler? Update Like GMail, that runs in the browser (with a lot of Javascript) and submit and receive data with Ajax, for example.
View 2 Replies
Oct 9, 2010
I have created a virtual directory in IIS(7.0) to create web application using visual studio 2010 ultimate edition. But when i open the Browse option in visual studio to create http hosted website , it vs2010 keeps on teling me that i need to have IIS Component installed. below is the eror message;
To access local IIS websites, you must install the follwoing IIS components
You must run Visual studio in the context of an administrator account. For more information, press F1
NB:i have installed the IIS 7.0 and its running fine
OS: windows7 Home Professional
View 2 Replies
Jan 6, 2011
i have a mssql database in my local machine and i have a new mssql database on server
i created the local database with sql server express and in my server i have a sql server database
now all i need is to create the tables as it is in local database in my server database the data inside of database is not importent i just need the tables
how can i create my new database tables like in my local database with all trigers and relashen ships?
View 2 Replies
Apr 22, 2010
i hosted my application on the IIS 7
now i've a requirement to show the desktop alert on my IIS desktop when an event fires
View 1 Replies
Sep 3, 2010
i am new to asp.net. i like to learn asp.net and c#. when i try to connect to sql server, it asks server name. i don't know server name and it asks database name also. how to create database and where can i access like phpmyadmin. in phpmyadmin i can create database and tables.
View 9 Replies
Jan 3, 2011
I would like to make a website where you can type in the url [URL] and the webpage will retrieve the article and display it in the articles view.
How would I best go about doing this?
Would I use a SQL database? Xml files? Text Files?
View 1 Replies
Nov 8, 2010
how to create schema like below for my database... and why it usefull
dbo.Employees.EmployeeNumber,
dbo.Employees.LastName + ', N' +
dbo.Employees.FirstName AS [Full Name],
dbo.Employees.HourlySalary,
dbo.TimeSheets.TimeSheetCode, dbo.TimeSheets.Week1Monday,
dbo.TimeSheets.Week1Tuesday, dbo.TimeSheets.Week1Wednesday,
dbo.TimeSheets.Week1Thursday, dbo.TimeSheets.Week1Friday,
dbo.TimeSheets.Week1Saturday, dbo.TimeSheets.Week1Sunday,
dbo.TimeSheets.Week2Monday, dbo.TimeSheets.Week2Tuesday,
dbo.TimeSheets.Week2Wednesday, dbo.TimeSheets.Week2Thursday,
dbo.TimeSheets.Week2Friday, dbo.TimeSheets.Week2Saturday,
dbo.TimeSheets.Week2Sunday
FROM dbo.Employees INNER JOIN dbo.TimeSheets
View 2 Replies
Mar 19, 2011
I want to attach the sql server database to my asp.net web application. How can i do it ?
View 1 Replies
Aug 11, 2010
I have created a script with pulish to provider button on VS 2010 and I need to deploy my database to my sql server.How can I do that ?
I cannot create a copy of my database on sql server with sql script file.
View 3 Replies
Nov 29, 2010
Is it possible to create a MS SQL 2005 database using Visual Studio 2008?
How about using Visual Web Developer 2008 Express Edition?
View 3 Replies
Jul 18, 2010
I'm kind of at my wits end here as it appears not many others have had this problem so it's possible that I'm missing something very simple but what is it?
I'm using SQL Express 2008 R2, Visual Web Devel Express 2010, .NET framework 4 and tell me whatever else you need to know.
I'm not being able to use add new item feature to insert an empty SQL database into my little project. It tells me connection to a .mdf file require SQL server to be installed and running on local computer. Well I can connect to server with management studio and connect to it inside VS. Database explorer will show me a database when I manually connect using tools>connect to database then data source = Microsoft SQL Server. It then shows up in database explorer. So why isn't the add new item feature working for me? What gives?
View 1 Replies