Skip to main content

Steps to attach DataBase to .Net Application - App_Data folder.

Step 1:

Detach Database from SQL Server.
         i) Open Sql Server
         ii) Login to Server
         iii) Select the DB that you going to attach to application, and right click for the option to detach the DB.

Step 2:

Right click on app_data folder and click on add existing item and then select database which you want to add in app_data folder,DB will exist in C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\DATA\...

 Step 3:

Alter the your connection string as below:
<connectionstrings>
<add connectionstring="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\DBName.mdf;Integrated Security=True;User Instance=True  " name="ConnectionName" providername="System.Data.SqlClient" />
</connectionstrings>

Comments

Post a Comment

Popular posts from this blog

Difference between NPM and NPX

NPM Vs NPX npm  - Javascript package manager npx  - Execute npm package binaries https://docs.npmjs.com/files/folders#executables If you use  npm 5.1 or earlier , you can't use npx. Instead, install create-react-app globally: npm install -g create-react-app Now you can run: create-react-app my-app NPM: One might install a package locally on a certain project: npm install some - package Now let's say you want NodeJS to execute that package from the command line: $ some - package The above will  fail . Only  globally installed  packages can be executed by typing their name  only . To fix this, and have it run, you must type the local path: $ ./ node_modules /. bin / some - package You can technically run a locally installed package by editing your  packages.json  file and adding that package in the  scripts  section: { "name" : "whatever" , "version" : "1.0.0" , "scripts" : { ...
Post a Comment
Read more

Books To Refer

1. C#   in Depth ,  Third   Edition : Foreword   by Eric   Lippert        By:  Jon Skeet    Publication Date:  16-SEP-2013 2. Learning jQuery - Fourth Edition     B y:  Jonathan Chaffer; Karl Swedberg     Pub. Date:  June 25, 2013      3.Beginning JSON                    By:  Ben Smith     Publication Date:  04-MAR-2014 4. Responsive Web Design with jQuery     By:  Gilberto Crespo      Pub. Date:  November 25, 2013 5. Developing Responsive Web Applications with AJAX and jQuery       By:  Sandeep Kumar Patel  P ub. Date:  July 25, 2014 6. Dependency Injection in .NET     by  Mark Seemann
Post a Comment
Read more

Create ASP.NET Core React-Redux Without Template

Node JS Visual Studio Code NET Core SDK (I’m using SDK version 2.2) Omni Sharp C# extension mkdir DotnetReactRedux cd DotnetReactRedux dotnet new mvc Code . npm init If you didn’t already install Webpack globally run below: npm install webpack -g npm install webpack-cli -g Then run below to add Webpack to your project npm i webpack –-save-dev npm i webpack-cli --save-dev open package.json file and add below { "name": "myapp", "version": "1.0.0", "description": "", "main": "index.js", "scripts": { "build": "webpack", "test": "echo \"Error: no test specified\" && exit 1" }, "author": "", "license": "ISC", "devDependencies": { "webpack": "^4.20.2", "webpack-cli": ...
Post a Comment
Read more