Hi, i have this big problem in my architecture : i want to build my object model by using the idea of collections, so i have a Customers object, a Customer object, an Orders object, and an Order object, and so on...
the Problem is that those custom business objects, hold my data, and of corse, i want to update my database by using the data in those object's, and oop's, the DataAdapter don't accept custome business objects as a parameter !! (only dataset are allowed).
I know that a dataset is also a collection of tables, and i could write my business objects as a dataset's and tables inside them, but with this method, i am obliged to accept the default names that the dataset generator create for me(i don't want to write all the code by my self !), and there is no way to change the names that the designer give to my tables...
So if i have for example a dataset that have a customers table and an Orders table, the designer will create a class named customersDataTable and OrdersDataTable...
what i can do if i want to create my business objects(by using my names) and in the same time, i can update my database using a DataAdapter (there is another method ) and also, fill my business object also ...
Why custom business object's while i can't update my database with them ?
Pecs
Hi people!
For the future, you can see the DLinq stuff:
http://msdn.microsoft.com/data/ref/linq/
http://download.microsoft.com/download/5/8/6/5868081c-68aa-40de-9a45-a3803d8134b8/DLinq_Overview_for_CSharp_Developers.doc
http://download.microsoft.com/download/5/8/6/5868081c-68aa-40de-9a45-a3803d8134b8/DLinq_Designer.doc
Other links about DLinq in
http://www.ajlopez.net/ReferenciaVe.php Id=124
Angel "Java" Lopez
http://www.ajlopez.com
chipper55
Hi Ahmad
I have been using NHibernate in commercial, production applications and I can very strongly recommend it. This framework has been around a long time and so is time-tested and proven in the real-world, so if you want something you can pick up and use today, this is definately one of the best tools out there for the .Net platform that will satisfy the needs you have expressed in your question.
Geoff
Karl David Anderson
Hello Ahmad,
You probably want an Object/Relational Mapping tool.
There are many options few examples include :
You may also want to look at tools like mygeneration http://www.mygenerationsoftware.com/portal/default.aspx - that can help you with generating code from schema or vice versa
Arnon
TonyStoker
Have a look at Persistor.NET. It is quite different to many O/R Mappers.
Hans-Peter
Adagio
You should note that at this time LINQ does not even have a "go-live" license
(see http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=400456&SiteID=1)
I wouldn't use it in prduction systems.
Arnon
Adam24
Thank you a lot, the linq project is greate, and i am surprised to see this project now, because it is excactly what i need, and i have downloaded the project, but i have a question: if a build my project by using this new technology, my client can run my project in their computer by using the dotnetfx.exe only or they also must download an update
Krishnaraj L
You need to install the project on the client, if you reference the namespaces in the client program.... Also, you can program a distributed app where the LINQ/DLINQ needs be used only in the server code, and the client only received value objects/DTOs without relation with LINQ...
There is a forum like this, on LINQ:
http://forums.microsoft.com/MSDN/ShowForum.aspx ForumID=123&SiteID=1
Angel "Java" Lopez
http://www.ajlopez.com/