Anonymous Data Type In MVC

Sandeep Kumar

10y12.3k8100Article

MVCAnonymous Data Typeimplementation of Anonymous Data type

8 Comments

Join the conversation! Your thoughts help the community grow.

Humayun Kabir Mamun10y ago
Nice...
- Sandeep Kumar10y ago
  Thank you
Afzaal Ahmad Zeeshan10y ago
"var" is not anonymous type. Who told you that? "var" is just used to implicitly convert the returned data type to "whatever" compiler thinks should be the type. Anonymous types are something else, which this article does not cover, sadly.
- Sandeep Kumar10y ago
  var keyword use to create an anonymous type which has already given in this . Also it has written that anonymous is a class type
Santhakumar Munuswamy10y ago
Thanks for nice share
- Sandeep Kumar10y ago
  Thank you
Jaco Zwarts10y ago
Nice Article!!!!
- Sandeep Kumar10y ago
  Thank you

Introduction

Anonymous type does not contain any name but it implements the methods. Anonymous type is a class type which gets to known about the type of data at the time of compile only. Declaration of variables of anonymous data type is mandatory otherwise it will raise error. Var keyword is used to represent Anonymous type.

Syntax for Anonymous Type

Var q1=(“ from X in x select data field where condition”).First();

Var Q1=(“ From Emp in x select Emp where eid=Convert.ToInt2(TxtEid.Text)).First();

Implementing Anonymous Data Type in MVC to work with LINQ TO SQL

Step 1: Go to Visual Studio and select New project as in the following figure:

After selecting, New Project windows will appear. Now, after selecting Windows from installed template select Windows Forms Application and write the Application name, then click on Ok button.

After clicking on Ok button, go to solution explorer and click with right mouse button to Application and then select Add and New Item. After that select LINQ to SQL Classes from Add New Item window. After selecting LINQ to SQL Classes write with extension of dbml. Click on Add button as in the following figure:

After clicking on Add button go to Server Explorer and establish the connection as in the following figure:

After establishing the connection select the table and drop to DataClass1.dbml as in the following figure:

table

Go to Form design and design the form, then go to form.cs and write the following code,

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
namespace LinqEmployeeDetails
{
public partial class Form1: Form
{
public Form1()
{
InitializeComponent();
}
private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e) {
}
DataClasses1DataContext objbe = new DataClasses1DataContext();
private void Form1_Load(object sender, EventArgs e) {
// dataGridView1.DataSource = objbe.EmployeeDetails.ToList();
}
private void buttonInsert_Click(object sender, EventArgs e)
{
EmployeeDetail objed = new EmployeeDetail();
objed.Id = Convert.ToInt32(textBoxId.Text);
objed.Name = textBoxName.Text;
objed.Designation = textBoxDesignation.Text;
objbe.EmployeeDetails.InsertOnSubmit(objed);
objbe.SubmitChanges();
MessageBox.Show("Data has Inserted");
dataGridView1.DataSource = objbe.EmployeeDetails.ToList();
}
private void btnUpdate_Click(object sender, EventArgs e)
{
var rec(From Empinobjdc.Employee where Emp.Eid = Convert.ToInt32(txtEid.Text) Select Emp).First(); //Using Var as Anonumous Type
rec.EName = txtEName.Text;
rec.EDesignation = txtDesignation.Text;
rec.ESalary = Convert.ToInt32(txtESalary.Text);
objdc.SubmitChanges();
MessageBox.Show("Record is Updated");
}
private void btnDelete_Click(object sender, EventArgs e)
{
var rec(From Empinobjdc.Employee where Emp.Eid = Convert.ToInt32(txtEid.Text) Select Emp).First(); //Using Var as Anonumous Type
objdc.Employee.DeleteOnSubmit();
objdc.SubmitChanges();
MessageBox.Show("Record is Deleted");
}
private void btnFind_Click(object sender, EventArgs e)
{
var rec(From Empinobjdc.Employee where Emp.Eid = Convert.ToInt32(txtEid.Text) Select Emp).First(); //Using Var as Anonumous Type
txtEName.Text = rec.EName;
txtDesignation.Text = rec.EDesignation;
txtESalary.Text = rec.ESalary.ToString();
}
}
}