i red some stuff, and what i got is that mvs normally works not directly with MSSQL on pc but witht he one it creates within project.. hm.. like that, and you can not see the database created from the project in normal SQL server databases.
View 2 Replies
I'm having trouble connecting to my model to my existing database using Entity Framework . Here is the code I'm working with:
[Code]....
Im testing something on a MojoPortal where i need to seperately add a Facebook connect button and make the user get registered with the website's registration! How do i do that?
View 2 Repliesyou could create your own custom Profile provider that operates against existing database tables .i want u to help me out if u have an idea where i can get steps by steps to carry out the above operation.i know there are various options in creating profile , particularlly the use of web. configuration, the default ASPNETDB, and XML files, BUT i wish to use an existing database which i prefer.
View 11 RepliesCreating a system with web front end and SQL backend (microsoft obviously). I have tried using the asp.netsqlprovider but i can;t as i am only allowed one database on the server, so i then tried to update my current database with the triggers to input the schema into the already existing database.Next step i create my own table with two simple fields of username and password and try and authenticate that way, i can't get that to work either.
I ahve limited permissions on the network as i am a University Student. I really don't know what to do. Never had to create a log on system before and i thought it would be far simpler than this. I ahve used Microsoft's sqlprovider schema before and it worked fine. I have also authenticated via IIS and AD too before. I can't do any of those two in this instance it seems.I need an alternative for logging in users, if needs be in can be crude. I also still need to have some kind of two different views too for logged in users and not logged in users, but that can change if needs must.Don't let me down people, haha. Think this posts in the correct place, i could not find another one i thought could be more relevant.
I have an existing SQL database containing student:class enrollments and would like to add a login feature using asp.net's built in Membership and Roles management tools. to how to integrate the Application Services Database with an existing SQL database? Once I have created the Application Services tables using aspnet_regsql tool how and where do I create a link between my tables and the .Net Membership tables?
View 5 RepliesI have a development database and one in production. There are two different sets of data in each database. On my dev system, I have mostly dummy data that I test with and in production is the real data for my web application. I recently added a new feature to the app that required a new table, and a new field for a foreign key in an existing table. I now need to upload that new structure to the production database without overwriting the live data with my test data.
If I run the Database Publishing Wizard, and choose "Schema Only" will it import the new structure and leave the existing data alone, or will it drop the records in my production database tables?
I have created a web application and an SQL database using Web Developer 2010 Express. I have SQL Server 2008 and SQL Server Management Studio Express. In order to deploy the database to my hosting space I need to create a .BAK file from my new database. I think I can do this from with the Management Studio, but can't figure out how to get it to connect to the database. I have used Management Studio before to retore another SQL database and the only connection I see when I open the Management Studio is the old connection to the old database. How do I connect to my new database?
View 6 Replieswhen I make restore to backup database display this error :
The backup set holds a backup of a database other than the existing 'elib' database. (Microsoft.SqlServer.Smo)
how I can solve this error ?
how to migrate an existing database from a specific application to a new Ms Access based application(database)?
View 4 RepliesPardon if this is a very dumb question, but I was trying to migrate an existing ASP application to asp.net MVC, and followed the procedure from the music store tutorial (http://www.asp.net/mvc/tutorials/mvc-music-store-part-4), which involves adding the
database to the App_Data folder. (I had to restart my machine before it would work, since otherwise, Visual Studio thought the database was being used by another application.)
Now when I check in Windows Explorer, it looks like the database file was literally copied into the App_Data folder, and now I have two mdf files on my hard drive with the same name. What is going on there?
Will my MVC app ignore the original (real) database and use it's own private copy instead? (That would be bad.) Or is the new copy just for reference when using wizards that generate entity classes etc.? If the latter, what is the procedure when the real
database is modified, to update the application code?
I was reading through this post here http://www.misfitgeek.com/op-ed/adding-asp-net-membership-to-your-own-database and thought to my self what the common practice is. What do developers using ASP.NET membership and authorization in their applications recommend as a best practice? creating the membership tables in the same database that stores their applications data or configuring a second database to store ONLY the membership information?.
My current setup is a different database for membership information ONLY but am thinking that increases the number of databases i have to maintain. If I have 5 applications using asp.net membership, then that means 5 more asp.net membership databases. So do you normally create the asp.net membership tables in your main database or you configure a separate membership table? what do you recommend.
I have an image (consider the image of a clock). I would like to change the position of the dials depending on values retrieved from database. (This will probably be done using a service which will run every minute or so.) I just want to know how I can change the image (i.e modify the existing image).This is for a dashboard screen. The images would be refreshed every minute to get the latest data.
View 3 RepliesI have not found information how to do the following:
how to add a new table using EFCodeFirst to the existing database aspnetdb.mdf?
This is something I asked about a long time ago but there wasn't really a solution available at the time. There was talk of there being changes in a new roll out of EF where existing databases based on a model were simply ammended instead of being dropped and recreated every time.I was wondering if anyone knows whether or not there is something out there now that will let me retain the existing data when making changes to a model? If not, what is the best way for me to back up the data prior to a change and restore it post-change?
View 1 RepliesI have the following code:
[code]...
and I'm trying to use that to submit to my database, but when I click on the submit button, no data is being inserted into my database, but I'm also not receiving any errors.
I moved to ASP.NET from PHP where the queries are run directly. So I always create Connection in the Page_Load Event, dispose it after I do all stuff needed, and access data with NpgsqlCommand. (Yes, I use Postgresql in my ASP.NET applications.)
After starting to learn ASP.NET MVC I was amazed how easy it is to access SQL with the LINQ to SQL thing. But... It works only with MS SQL. So my question is how to implement the same functionality in my applications? How to connect to databases easily?
I wrote my own wrapper classes for connecting to Postgresql. 1 class per a table.
This is a part of the Student class:
[Code]....
So as you see the problem here is that with every INSERT, DELETE, UPDATE request I'm using Connect() method which connects to the database. I didn't realize how stupid it was before I had to wait for 10 minutes to have 500 rows inserted, as there were 500 connections to the database.Using pooling while connecting does help, but still making the connection and making the server check the pool during every single query is stupid.So I decided to move Connection property to a static DB class, and it didn't work either, because it's a really bad idea to store such objects as connections in a static class.I really don't know what to do know. Yes, there's an option of manullay creating the connections in every Page_Load event and close them in the end like I'm doing it right now.
[Code]....
I am newbie to asp.net.I want to create roles for the existing users in my database. I dont want to use the membership provider database n roles provided with it.(i don't want to use aspnet.mdf at all)
I am create roles for my existing users n assign i wanted to assign the particular roles to a particular assign.
I was trying to upload the database of my ASP.NET website. On the local machine, if I copy the database from another machine, I have to attach it through SQL Server Management Studio and then use it in the connection string like
[Code]....
My database is approx. 10 MB in size for now. If I upload it via ftp to App_Data folder, how would I have to attach this database?In Plesk, I have the option to create the database and its user (as shown in the screenshots):1) Web Applications and services-Plesk2) Add New Databaseand add new database user3) Webadmin>ASP.ET Enterprise ManagerBut this is for the new database I created. My problem is to upload an existing one.There's also a section in Plesk for ASP.NET settings (as shown below)
This has the option to change the connection string etc.I also asked my hosting provider about the method to be followed for attaching the database that I would upload. This was the reply in quote." mdf ldf files perhaps will be working at your local computer but this way database of mssql will not work on web server as on web server you will be required to create and restore your database backup file using plesk control panel.
Sample connection string for asp.net
mssql `Standard Security`:
"Provider=SQLOLEDB;Data Source=Your_Server_Name;Initial Catalog=Your_Database_Name;UserId=Your_Username;Password=Your_Password;"
Server name to be used in coding: localhost Catalog/ database name , database user and database password you will be required to create your own using plesk control panelI would be really be appreciative for the steps I have to take to upload my existing database. How do I have attach it? What connection string I have to use?
I am running windows 7 and NET Framework 4.
Problem is I dont know how to locate the asp.reg.sql tool that will do this using windows 7.
how to do this?
Basically what i have is a button and i want this button to add value in database, i mean if the value in the database is 1 it adds 1 to it, so that the value becomes 2.
View 3 RepliesI have a table with several columns i created,
How can i add a new column and specify its data type now? i using sql server and Gridview.
I tried to add one using GridView but it shows me columns called edit delete something is not like my bound fields i created early.
I have an ASP.NET application with existing business classes and a database schema. (which I would like to keep) Currently I am using ADO.NET for the DAL, but I would like to switch to some advanced technology there for easier data retrieval.
Is EF applicable to my situation? Can I use it without splitting up my business classes and auto code generation? Can LINQ to SQL solve my problem better?
All I want to do is map my existing classes to the existing tables and dont have to handle details of the data retrieval myself.
i would like to use asax to check my database for every 5 min. if let say the database detect high in threshold.. it will send a notification to administrator. Anyone have done this before mind to share some code?
View 29 RepliesI have already created the database for my website, however when i create the webforms such as a student sign up form i dont know how to connect the text boxes to the database to its relevant table, so data can be updated and deleted. I am aware of the grid view and form view tools but when using those tools I can't seem to move the labels and text boxes around the webpage for design purposes.
View 5 Replies
