Binding of the SQL variables with the MVC model class variables in MVC project

Question

1.00/5 (1 vote)

See more:

I have a MVC project in which i generate drop-down dynamically from SQL. Now when the SQL returns the variables, it matches it with mvc model to map with variables. but in need only three model variable. bu t it shows that all the model variables must match the SQL variable. it seems like it is strongly typed model. it asks for all model variables where as i only need few variables from model to match with SQL query. Kindly Help as soon as possible

What I have tried:

i tried to modify the models as well as SQL query but all in vain

Posted 10-Feb-19 20:18pm

Sam_k_khan

Updated 10-Feb-19 22:25pm

v3

Add a Solution

Comments

Wastedtalent 11-Feb-19 2:59am

Without the code it's hard to totally understand your issue, but I would imagine you may need a model for your SQL and the model for your view, and a service that maps between the two.

Sam_k_khan 11-Feb-19 3:03am

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;

namespace Login.Models
{
public class Datesheet
{
public string ExamName { get; internal set; }
public long Id { get; set; }
public string Name { get; set; }
public string Dated { get; set; }
public string MaxMarks { get; set; }
public string MinMarks { get; set; }
public string From { get; set; }
public string To { get; set; }
public string Type { get; set; }

}
}

Sam_k_khan 11-Feb-19 3:06am

this is my model. from sql query i need only Name and Id of this project. But on load it asks that all model varaibles should be returned from sql

Sam_k_khan 11-Feb-19 3:07am

sql query is as folllows:
select Id , Name from tbl_abcd

Now when this Id And Name is mapped with the model above it asks for all other variables of this model. something like strongly typed

Sam_k_khan 11-Feb-19 3:14am

the error on my screen is

the data reader is incompatible with the specified 'Login.Models.Datesheet'. A member of the type, 'MaxMarks' does not have a corresponding column in the data reader with the same name

Wastedtalent 11-Feb-19 3:35am

If you don't need all those fields, why have them, else create a new model that has just those fields you need and use that for this purpose, you could even use as a base and extend eg (I've assumed the name is for a student but I've no idea, so change accordingly):

public class Student
{
public string Name { get; internal set; }
public long Id { get; set; }
}

public class Datesheet : Student
{
public string ExamName { get; set; }
public string Dated { get; set; }
public string MaxMarks { get; set; }
public string MinMarks { get; set; }
public string From { get; set; }
public string To { get; set; }
public string Type { get; set; }
}

And map the sql query to the student object.

Sam_k_khan 11-Feb-19 3:41am

kindly check my rest replies

Sam_k_khan 11-Feb-19 3:39am

but i was working fine yesterday. it returned only matching variables successfully. then i dont know what feature of visual studio was updated and then everything went wrong. before this it was mapping only matching variables perfectly

Wastedtalent 11-Feb-19 3:42am

What is the full code for where you're executing the SQL query?

Sam_k_khan 11-Feb-19 3:41am

if your last comment is the case then i will have to make changes in the whole project. which was working fine before. That is very problematic for me this moment. can u tell me what can cause this situation.

Wastedtalent 11-Feb-19 3:47am

The query needs to match the entity, alternatively just do

select * from tbl_abcd

Sam_k_khan 11-Feb-19 3:49am

in a nutshell, i need the way where i can map only few variables of model with SQL returned variables, even though if the mvc model contains more variables

#realJSOP 12-Feb-19 13:53pm

Then you need to either a) create another model with just the fields you need, or b) create a base model that includes just the fields you need, and derive another model from it for use elsewhere.

Sam_k_khan 11-Feb-19 3:51am

public List<selectlistitem> GetCources()
{
var res = from item in GetstuCources.AsEnumerable()
select new Examination { Id = item.Id, Name = item.Name };
List<datesheet> drplist = res.ToList();
List<selectlistitem> itms = new List<selectlistitem>();
itms = drplist.ToSelectList(m => m.Name, m => m.Id.ToString(), "0", "Select Course", true);
return itms;
}

public IEnumerable<datesheet> GetstuCources
{
get
{
IEnumerable<datesheet> size = Database.SqlQuery<datesheet>("exec ANDROID.ash_Course_View");
return size;
}
}

Sam_k_khan 11-Feb-19 3:52am

is that .net framework issue???

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Binding of the SQL variables with the MVC model class variables in MVC project

Add your solution here

Preview 0

Binding of the SQL variables with the MVC model class variables in MVC project

Add your solution here

Preview 0

Existing Members

...or Join us