On Mon, Jul 16, 2012 at 10:52 AM, jtaylor <jtay...@lorencook.com> wrote:
> My C# is incredibly rusty, so I am having trouble following your code.
> Also, there is no backend DB. The data will be extracted at runtime from
> various non-structured sources.
>
>
> On Monday, July 16, 2012 8:18:21 AM UTC-5, srussell705 wrote:
>>
>> On Fri, Jul 13, 2012 at 9:15 AM, jtaylor <> wrote:
>> > I am building an in-memory DataSet from non-structured data. I need
>> > to JOIN and query data across tables. DataTable has a .Select method
>> > but DataSet does not. I tried to use LINQ, but it gives me a
>> > "Expression of the type 'System.Data.DataTable' is not queryable.
>> > Make sure you are not missing an assembly reference and/or namespace
>> > import for the LINQ provider.", and I cannot find anything missing.
>> >
>> > What is the best way to SELECT across tables within a DataSet?
>> --------------
>>
>> Don't use DataSet or DataTable for your container. Put it into an data
>> object:
>> var myPO = (from p in db.PurchaseOrders
>> // Query of data from backend
>> where p.dtmAdded >= pastdate
>> orderby p.dtmAdded descending
>> select new PO
>> // Data object loading is below
>> {
>> dtmAdded = (DateTime)p.dtmAdded,
>> errorChecked = (Boolean)p.ErrorChecked,
>> poCurrency = p.POCurrency,
>> poDate = p.PODate,
>> poID = (Int32)p.POID,
>> poNumber = p.PONumber,
>> poStatus = p.POStatus,
>> poTime = p.POTime,
>> printed = (Boolean)p.Printed,
>> referenceID = p.ReferenceID,
>> requestMade = (Boolean)p.RequestMade,
>> tradingPartnerID = p.TradingPartnerID
>> }).ToList();
>> return myPO;
-----------------------
This site is pretty good with conversion between the two languages.
http://www.developerfusion.com/tools/convert/csharp-to-vb/
--
Stephen Russell
Sr. Analyst
Ring Container Technology
Oakland TN
901.246-0159 cell
--
You received this message because you are subscribed to the Google
Groups "DotNetDevelopment, VB.NET, C# .NET, ADO.NET, ASP.NET, XML, XML
Web Services,.NET Remoting" group.
To post to this group, send email to dotnetdevelopment@googlegroups.com
To unsubscribe from this group, send email to
dotnetdevelopment+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/dotnetdevelopment?hl=en?hl=en
or visit the group website at http://megasolutions.net
