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):
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?
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)
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.
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".
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.
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.
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.
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..
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
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
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.
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.
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
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?
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.
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?
