On Mon, Dec 15, 2008 at 1:57 PM, Geoff Flight <[email protected]> wrote:
> The ADO way thru .NET seems confusing at first because VFP was just SO
> simple and easy. But eventually it makes sense. It was my hardest learning
> curve - getting used to the fact that data access was 1000 times harder than
> in fox.
-----------------------------
Now it is pretty simple this is data to use in a listbox.
public List<ShippingProviders> GetShippingProviders()
{
using (myVPCEntities LDB = new myVPCEntities())
{
var shippingProviders = (from SP in LDB.ShippingProvider
select new ShippingProviders
{
CarrierID = SP.Guid ,
CarrierName = SP.DisplayName
}).ToList();
return shippingProviders;
}
}
LDB = the Entity Framework that has all the connections to the db for
me. I can see all the objects that I have included from the DB into
the entity. Those objects are tables, views and SPs. As I am defining
the ShippingProviders mapping { CarrierID = SP.Guid ,} after I type
SP. the intellisense presents the list of all parts of the
ShippingProvider object from the db for me.
--
Stephen Russell
Sr. Production Systems Programmer
Mimeo.com
Memphis TN
901.246-0159
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message:
http://leafe.com/archives/byMID/profox/[email protected]
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
