how pick data in listbox from db?

Question

i am developing software using VS 2008 and at back end Oracle 10g.

my first question is: can i use LINQ for oracle? or/and

is there a way without using LINQ can i join more than one source to collect result. e.g. i have two dataset one is for category named cat_set and 2nd for product named prd_set now i want to list the product on the basis/specific to selected category in 2nd set.

i made two dataset. one for category which upload data from db in combobox and 2nd in ListBox but only for selected category in the combobox.

thanks in advance.

Answer 1

There are quite a few ways to connect to Oracle and use LINQ:

• DevArt has DotConnect for Oracle that supports Oracle, so you can use Linq to query your underlying data

• Mindscape LightSpeed is an ORM (alternative to Linq-to-SQL or EF) which also supports Oracle as a backend and has full LINQ support

There are other projects out there, but I don't really know much about them (how complete and how stable and reliable they are).

I don't quite understand your second question about joining two datasets to fill a dropdown - can you elaborate a bit? Can you give us an idea what these two datasets look like (what fields they have), and which pieces you'd like to show up in the combobox? Which should be the display field, which should be the value field?