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:

SQL Server :: How To Create Database Programmatically From .bak File

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

Web Forms :: How To Create SQL Server Database Programmatically In C#

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

Security :: Create A Login Control Programmatically For Sql Server 2005?

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

SQL Server :: Programmatically Store Record Into Database?

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

SQL Server :: Windows Shared Hosting Error: Create Database Permission Denied In Database 'master'?

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

Configuration :: Create Setup For Web Application With Database?

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

SQL Server :: Create & Manage A Database Which Is In Computer With Sql Server Management Studio

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

SQL Server :: Create Dbo Database Table Schema On The Shared Server?

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

SQL Server :: What Will Happen If Two Application Servers Communicate One Database Server

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

SQL Server :: Create Password In SQL Server Single Database

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

How To Create Pdf Reports From Sql Server In MVC 2 Application

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

How To Create The Web Application Using Asp.net 2.0, C# And Sql Server 2005

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

Configuration :: Create A Server For A Application?

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

Create Server Side To A Pure Javascript Application?

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

Configuration :: Unable To Create Web Application In Local IIS Server

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

SQL Server :: How Create A New Database From An Old One

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

Web Forms :: Create Desktop Alert Using Application On Hosted Server?

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

How To Create Database In Sql Server 2008

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

SQL Server :: Create An Articles Database In C#?

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

SQL Server :: Create Schema In Database?

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

Sql Server - Attaching Sql Database To Web Application?

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

SQL Server :: Unable To Create A Copy Of Database ?

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

SQL Server :: How To Create A Sql 2005 Database Using Vs 2008

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

SQL Server :: How To Create Empty Database Using Add New Item

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







Copyrights 2005-15 www.BigResource.com, All rights reserved