<div>
<div class="content wysiwyg-content">
I have the following query and I need to know how to convert it to linq:<br />
<br />
select c.video_Name, a.detail_id, a.video_version, nvl(b.min_assets,4) min_assets, nvl(b.max_assets,1000) max_assets<br />
from video_detail a,<br />
&nbsp; &nbsp; &nbsp; &nbsp; video_stage b,<br />
&nbsp; &nbsp; &nbsp; &nbsp; video c<br />
where a.detail_id = :Vdetail_id<br />
and a.status = 'A'<br />
and c.video_id = a.video_id<br />
and a.video_id = b.video_id<br />
<br />
<br />
Thank you!
</div>
</div>


I have the following query and I need to know how to convert it to linq:

select c.video_Name, a.detail_id, a.video_version, nvl(b.min_assets,4) min_assets, nvl(b.max_assets,1000) max_assets
from video_detail a,
        video_stage b,
        video c
where a.detail_id = :Vdetail_id
and a.status = 'A'
and c.video_id = a.video_id
and a.video_id = b.video_id


Thank you!

C#/LINQ

Most development for the Microsoft platform is done utilizing the technologies supported by the.NET framework. Other development is done using Visual Basic for Applications (VBA) for programs like Access, Excel, Word and Outlook, with PowerShell for scripting, or with SQL for large databases.

Microsoft Development

Language Integrated Query (LINQ) is a Microsoft .NET Framework component that adds native data querying capabilities to .NET languages, although ports exist for Java, PHP, JavaScript and ActionScript. LINQ extends the language by the addition of query expressions, which are akin to SQL statements, and can be used to conveniently extract and process data from arrays, enumerable classes, XML documents, relational databases, and third-party data sources.