asp.net core mvc - The required column was not present in the results of a 'FromSql' operation -

-

i've starting learning mvc6 ef7. have stored proc i'd return portion of fields in model. if don't return every field in model, i'm getting "the required column 'firstname' not present in results of 'fromsql' operation".

is there way make columns not required can return portion of fields in model?

model:

public class loginviewmodel {     [key]     public int userid { get; set; }      [required]     [display(name = "username")]     public string username { get; set; }      [required]     [datatype(datatype.password)]     [display(name = "password")]     public string password { get; set; }      [required]     [datatype(datatype.password)]     [display(name = "protected id")]     public string protectedid { get; set; }      public string firstname { get; set; }     public string lastname { get; set; } }

my proc testing:

create procedure [dbo].[aaa_topxxuserstest] @numtoreturn int = 10 begin     set nocount on;     select top(@numtoreturn) userid, lastname, username,password, protectedid users deleted = 0  end

and last, controller code:

public iactionresult index() {     var user = _context.set<loginviewmodel>().fromsql("dbo.aaa_topxxuserstest @numtoreturn = {0}", 20);      return view(user); }

if include fields of model in stored proc call work fine, can't seem return subset. there way make of fields not required?


Comments

Post a Comment

Popular posts from this blog

Django REST Framework perform_create: You cannot call `.save()` after accessing `serializer.data` -

-
i have following viewset: class artistprofileviewset(viewsets.modelviewset): queryset = artistprofile.objects.all() serializer_class = artistprofileserializer def perform_create(self, serializer): if serializer.is_valid(): serializer.save() with following serializers: class simpleartisttrackserializer(serializers.hyperlinkedmodelserializer): class meta: model = artisttrack fields = (...my fields...) class artistprofileserializer(serializers.hyperlinkedmodelserializer): owners = userserializer(many=true, required=false) tracks = simpleartisttrackserializer(many=true, required=false) class meta: model = artistprofile fields = (...my fields...) i getting following error: assertionerror: cannot call `.save()` after accessing `serializer.data`.if need access data before committing database inspect 'serializer.validated_data' instead. i don't see editing serializer.data object. th...
Read more

Why does Go error when trying to marshal this JSON? -

-
i'm trying rather simple example of trying decode json file structs using golang. however, when attempting error that json: cannot unmarshal object go value of type []main.track which don't understand. here's code in question, , json can found here . package main import ( "encoding/json" "fmt" "net/http" "os" ) // tracks group of track types type tracks struct { tracks []track } // track represents singular track type track struct { name string url string artist artist } // artist represents single artist type artist struct { name string mbid string url string } func main() { url := "http://ws.audioscrobbler.com/2.0/?method=geo.gettoptracks&api_key=c1572082105bd40d247836b5c1819623&format=json&country=netherlands" response, err := http.get(url) if err != nil { fmt.printf("%s\n", err) os.exit(1) } de...
Read more