Article View: alt.pl.comp.lang.csharp
Article #21194Re: Procki w MVC 1.0 i LINQ
From: Łukasz Kuryło
Date: Thu, 03 Dec 2009 18:47
Date: Thu, 03 Dec 2009 18:47
34 lines
2647 bytes
2647 bytes
> public IQueryable<Book> Pokaz(int bookID)
> {
> int ? outputParameter = bookID;
> // bookID = 1;
> return from bookdetail in db.BookDetail(ref
> outputParameter)
> select db.BookDetail;
> }
return from b in db.BookDetail
where b.bookID==bookID
select b //albo new <jakis obiekt> i mapujesz do niego obiekt book
pobrany przez linq
> Wiesz może jak to obejść? Próbowałem już select
> db.BookDetail.AsQueryable(); ale coś nie działa.
A skoro pobierasz tylko jedną książkę (bo zakładam, że bookID jest
unikalny), to iqueryable jest zbędne. Oczywiście zależy to od Twojego
sposobu pracy. Ja po prostu zwracam jeden konkretny obiekt. W moim
kodzie ta metoda wyglądałaby tak:
public Book Pokaz(int bookID)
{
var result=from b in db.BookDetail
where b.bookID==bookID
select new Book{
bookID=b.bookID //i reszte
};
return result.FirstOrDefault();
}
Technical Details
Message-ID:
<bbcd71f8-e870-4ebf-a8eb-23db32e8c901@j24g2000yqa.googlegroups.com>Path:
mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!news.gazeta.pl!newsfeed.pionier.net.pl!news.glorb.com!postnews.google.com!j24g2000yqa.googlegroups.com!not-for-mailReferences:
<c87af13e-23ef-433c-b35b-5d26ad8a212a@g26g2000yqe.googlegroups.com> <6f49f6e0-56ab-4ba6-becb-c4ec2e4bf2ec@m3g2000yqf.googlegroups.com> <7fb4fad8-93d8-4251-973b-434b1f13baac@a21g2000yqc.googlegroups.com> <694e50e1-3cca-4b17-a215-a41eb57c8d5c@m38g2000yqd.googlegroups.com>Show Full Headers
Complete Article Headers
Path: mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!news.gazeta.pl!newsfeed.pionier.net.pl!news.glorb.com!postnews.google.com!j24g2000yqa.googlegroups.com!not-for-mail From: Łukasz Kuryło <lszk86@gmail.com> Newsgroups: alt.pl.comp.lang.csharp Subject: Re: Procki w MVC 1.0 i LINQ Date: Thu, 3 Dec 2009 10:47:47 -0800 (PST) Organization: http://groups.google.com Lines: 36 Message-ID: <bbcd71f8-e870-4ebf-a8eb-23db32e8c901@j24g2000yqa.googlegroups.com> References: <c87af13e-23ef-433c-b35b-5d26ad8a212a@g26g2000yqe.googlegroups.com> <6f49f6e0-56ab-4ba6-becb-c4ec2e4bf2ec@m3g2000yqf.googlegroups.com> <7fb4fad8-93d8-4251-973b-434b1f13baac@a21g2000yqc.googlegroups.com> <694e50e1-3cca-4b17-a215-a41eb57c8d5c@m38g2000yqd.googlegroups.com> NNTP-Posting-Host: 83.238.173.152 Mime-Version: 1.0 X-Trace: posting.google.com 1259866067 17082 127.0.0.1 (3 Dec 2009 18:47:47 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Thu, 3 Dec 2009 18:47:47 +0000 (UTC) Complaints-To: groups-abuse@google.com Injection-Info: j24g2000yqa.googlegroups.com; posting-host=83.238.173.152; posting-account=SpSbMAkAAABUouo3zeQ4nUG0saYciwqW User-Agent: G2/1.0 X-HTTP-Via: 1.1 serwerpiekary:55900 (squid/2.7.STABLE3) X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; pl; rv:1.9.1.5) Gecko/20091102 Firefox/3.5.5 (.NET CLR 1.1.4322; .NET CLR 2.0.50727; .NET CLR 3.0.04506.648; .NET CLR 3.0.4506.2152; .NET CLR 3.5.21022; .NET CLR 3.5.30729),gzip(gfe),gzip(gfe) Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit