Another strange problem...

Curious Cat 21

I am entering data into a table. During this (In the OnPostAsync scope), I do send an query to an another table, to obtain a missing data that doesn't is included in the data which comes the from.
But at each try i get a strange rendered result.
It says :
Microsoft.EntityFrameworkCore.Query.Internal.EntityQueryable`1[OtoServisWeb.Models.Stoklar]
What do I wrong ?
Below is the part where i got the issue :

public IEnumerable<Stoklar> Stoklar { get; set; } // Same result also with IList....  

public async Task<IActionResult> OnPostAsync()  
        {  
            var stokkod = YedekParca.StokKod; // This value comes from the form....  
            var stokadi = _appDbContext.Stoklar.Where(s => s.StokKod == stokkod); // here the query....  
  
            YedekParca.StokAd = Convert.ToString(stokadi); // and with this i add to Db Table....  
  
                _appDbContext.YedekParca.Add(YedekParca);  
                await _appDbContext.SaveChangesAsync();  
  
                return RedirectToPage("CreateReport", new { id = YedekParca.IsId });  
        }

And in the DB Table i find this instead my value :
Microsoft.EntityFrameworkCore.Query.Internal.EntityQueryable`1[OtoServisWeb.Models.Stoklar

AgaveJoe 26,191 Reputation points

2022-11-01T12:56:36.17+00:00
The results are expected beacuse stokadi is a collection type. Use FirstOrDefault if one record is expected.

var stokadi = _appDbContext.Stoklar.FirstOrDefault(s => s.StokKod == stokkod).Stokadi;

You might want to go through a few tutorials before moving forward.

Razor Pages with Entity Framework Core in ASP.NET Core - Tutorial 1 of 8
Curious Cat 21 Reputation points

2022-11-01T13:07:31.22+00:00

Result with SingleOrDefault ;

System.Runtime.CompilerServices.AsyncTaskMethodBuilder1+AsyncStateMachineBox1[OtoServisWeb.Models.Stoklar,Microsoft.EntityFrameworkCore.Query.ShapedQueryCompilingExpressionVisitor+<SingleOrDefaultAsync>d__15`1[OtoServisWeb.Models.Stoklar]]
AgaveJoe 26,191 Reputation points

2022-11-01T13:23:11.93+00:00

It seems you do not understand types and collections in C#. Unfortunately, you did not provide the models so we have no idea how your database is designed. Please go through the tutorial in my last post to learn fundamental patterns in Razor Pages and working with Entity Framework rather than guessing.
Curious Cat 21 Reputation points

2022-11-01T13:29:43.633+00:00

I felt like I was being reprimanded. Sorry for keeping you busy.
AgaveJoe 26,191 Reputation points

2022-11-01T13:40:04.07+00:00

I'm sorry you feel that way. Your first code sample tries to convert a collection to a string. "Microsoft.EntityFrameworkCore.Query.Internal.EntityQueryable`1[OtoServisWeb.Models.Stoklar]" is expected.

You did not share the updated code so I have no idea what you're doing. Good luck.

Curious Cat 21

public class Stoklar  
    {  
        [Key]  
        public int StokId { get; set; }  
        [Required]  
        public string StokAd { get; set; }  
        [Required]  
        public string StokKod { get; set; }  
        public string? Marka { get; set; }  
        public string? Aciklama { get; set; }  
        public bool Durum { get; set; } = false;  
    }

The Model i try to query is above...

Below is just a part of the code. cause its long and there are no porblems.
Problem starts;
During insert a huge amount of data in my table below, i need the "StokAdi" value. It is not included in the form from where all the data comes. So thats why i query Stoklar model to catch the value and insert it in the table with the other data at once.

public async Task<IActionResult> OnPostYedekParcaEkleAsync()  
        {  
            var stokadi = _appDbContext.Stoklar.FirstOrDefaultAsync(s => s.StokKod == YedekParca.StokKod);  
  
            YedekParca.StokAd = Convert.ToString(stokadi);  
  
                _appDbContext.YedekParca.Add(YedekParca);  
                await _appDbContext.SaveChangesAsync();  
  
                return RedirectToPage("CreateReport", new { id = YedekParca.IsId });  
        }

AgaveJoe 26,191 Reputation points

2022-11-01T14:05:53.38+00:00
You are making the same mistake. This time the code tries to convert the type "Stoklar" to a string.

Simply return the property you're looking for. Also, I recommend that you stop using var until you have a better idea what type is returned from LINQ expressions.

Stoklar stoklar = _appDbContext.Stoklar.FirstOrDefault(s => s.StokKod == YedekParca.StokKod); YedekParca.StokAd = stoklar.StokAd
Curious Cat 21 Reputation points

2022-11-01T14:36:04.46+00:00

Ok ok...
i found it,

Pasted the codes there as you wrote. But i just missed "await" there...
that was the problem. It works now.

Thank you for your patience and help.
AgaveJoe 26,191 Reputation points

2022-11-01T14:56:03.983+00:00
After taking a closer look, you forgot to await the async call. Really you are converting a Task to a string.

Because Stoklar is used already in my codes for another query. My page is a bit complex.

Not true! Stoklar is a type. There is no limit to the number of Stoklar types created in a code block. However, the variable name "stoklar" must be unique. If you've already defined a variable named "stoklar" then use a different name like result or whatever you like.

Stoklar result = await _appDbContext.Stoklar.FirstOrDefaultAsync(s => s.StokKod == YedekParca.StokKod); YedekParca.StokAd = result .StokAd

You can also get the property using the following pattern but I'm afraid that will lead to more confusion.

string MyStokAd = (await _appDbContext.Stoklar.FirstOrDefaultAsync(s => s.StokKod == YedekParca.StokKod)).StokAd;