CREATING INTERNET APPLICATION PROJECT & MVC USING DATA BASE FIRST APPROACH

In this we are going to see about how to create a project in visual studio and the concept of mvc.
Here in this demo we are creating internet application base project.
Step 1: Open the Microsoft Visual Studio.

Go to File in that go to new and select Project.

In new project select Visual C# , In that  select ASP.NET MVC 4 Web Application. After selecting the project type give the name of the project and the desired location where you want to save your project and press ok. In my case I am giving my project name as my first project.


After pressing ok a page will appear for selecting template to which we want to run our project.

Here we are selecting our template as Internet Application. Internet Application is a account controller that uses forms and authentication. Our view engine will be Razor. After pressing ok project is generated.

Now let us see about MVC (MODEL VIEW CONTROLLER).
Model : It should be responsible for the data of application domain.
View : It presents the display of the model in the  user interface.
Controller : It is really the heart of  the MVC, the intermediary that ties the Model and the View together, i.e. it takes the user input, manipulate the model and causes view to update.
There are three fields with which we are working with in ASP.NET:
1.      Model first approach
2.      Data Base first approach
3.      Code first approach
Now let us see about Data Base first approach:
The Data Base first approach provides an alternative to the Code first  & Model first approaches to Entity Data Model and it creates Model Codes (Classes, Properties, Db context etc) from the database in the project and those classes become the link between the database and controller.

Now let us see how to connect with the database. In the Visual Studio window go to Solution Explorer in solution explorer go to Model right click on the model and click add a drop down window will appear in that go to new item and press it as shown in the below figure.

 After pressing new item a window will appear in that select ADO.NET Entity Data Model and press add

After pressing add choose model content as Generate From Data Base as shown in the below figure.

Press next after selectiong model content a window will appear asking for name of connection to connect with database.

Press new connection A window will appear asking for server name and database name, press the server name and the database name which you have created in your sql server. My database name is management as I have created a database with name as management.

After pressing ok a connection with entity connection string is generated.

Press next a window will appear asking for database objects to be included in the model I am selecting tables to be included in my model.

Press finish out table from the database is added.

Go to HomeController.cs in that go to Public ActionResult and give a name to it I am giving action result name as employee.

After  that rightclick on the action view and press add view





Go to use a layout or master page and select Shared from the project folder and Cshtml from the content folder as shown in below figure.


Press ok a page will be generated in that page insert Html code.

After putting the html code press run button, to run the code.


Local host will be generated in that give the controller name .


Comments

Post a Comment

Popular posts from this blog

How to create DATA BASE And Tables in MSSQL Server

Step 1.  Press Windows Button in that search for SSMS, Image will appear like this                           click on this image Microsoft SQL Server Management Studio window will open. Step  2.  Enter Server name if it’s not available as default, else connect to default server  by pressing  connect in login window. Step  3. After perfectly login a window will open in that a sub window by name Object Explorer will be there. Step 4. In Object Explorer  right click  on the Data Base in that press new Data Base. Step  5.  Type any name in Database name bar. As I have created a new database as tested which will be explore in Databases in Object Explorer. Step 6. Explore the database which you have created as I have created database by name tested I am exploring my database in that go to tables. Step 7. Rig...
Read more

Data Type Conversions in C# with real time example

In This Post We Will Learn   Data Type Conversions 1.   Implicit Conversions 2.   Explicit  Conversions 3.   Different between Parse() and TryParse() Implicit Conversion is done by the compiler  1.  When there is no loss of  information if the conversion is done  2.  if there is no possibility of throwing  exception during the conversion  Example :  Converting an int to a float will not loose any data and no Exception will be thrown, hence an implicit conversion can be done. using System; namespace Datatypes_conversion {     class Program     {         static void Main(string[] args)         {            // Implicit Convertion Real Time Example              int r = 100;             float m = r;    ...
Read more

Real Time Example add dynamic fields using jquery looking Treeview

I have Implemented add Dynamic Fields Using jquery Look at code : <html> <head> <title>Dynamically add input field using jquery</title> <style> .container1 input[type=text] { padding:5px 0px; margin:5px 5px 5px 0px; } .add_form_field {     background-color: #1c97f3;     border: none;     color: white;     padding: 8px 32px;     text-align: center;     text-decoration: none;     display: inline-block;     font-size: 16px;     margin: 4px 2px;     cursor: pointer; border:1px solid #186dad; } input{     border: 1px solid #1c97f3;     width: 260px;     height: 40px; margin-bottom:14px; } .delete{     background-color: #fd1200;     border: none;     color: white;     padding: 5px 15px;     text-align: center;     text-decorati...
Read more

Nullable Type In C# with Example

IN THIS  POST WE WILL LEARN    1. NULLABLE TYPE IN C#    2. NULL COALESCING  OPERATOR   ??   Type in C# In C# types are divided into 2 broad Categories Reference Types :  Interface , Class , Delegates , Arrays E.t.c Value Types        : Int , Float , Double , Structs ,Enums E.t.c By Default value types are non nullable. To make then nullable Use   ? int r= 0 (r is non nullable, so r cannot be set null , r= null will generate Error ) int? m =0 (m is nullable int , so m=null is legal) Example :  Nullable Type  In C# using System; namespace NullableTypeInCshape {     class Program     {         static void Main(string[] args)         {             bool? AreYouvirgin = true;             if (AreYouvirgin ==true)         ...
Read more

Basic -C# Reading and writing to a console

     * Reading From the Console      * Writing to the Console      * Two Ways To Write Console            1)  Concatenation             2)  Place Holder Syntax Reading and Writing to Console  using System; //  A Namespace is used to Organize your code and is Collection of Classes     class Program     {         static void Main()  // Main Methods          {             // Prompt The User For His First Name              Console.WriteLine("Enter First Name");             // Read the name from Console              string firstname = Console.ReadLine();             // Prompt the User For His Last Name   ...
Read more