How to connect wpf with database

Mon, 03 Mar 2008 15:35:12 Z

how can I connect a WPF project to SQL Server 2005
I try to do it like I do in past with Windows Form Application
but I cant do it
I think that their is a new way to connect to database with WPF Application , so plz tell me about it and if any examples or links for help
thank you alot

How to connect wpf with database

Mon, 03 Mar 2008 16:23:06 Z

In WPF you could also use ADO.NET and bind e.g. to the tables in a dataset. But up to now there are now wizards in Visual Studio for data connection. E.g. you can't drop tables out of DataSource-Explorer onto your form. Possibilities:

Add a typed DataSet to your Project, add Tables and TableAdapters, use TableAdapters to load data and bind your UI to the Data
Instead of DataSets you could also use Linq to SQL and bind to your special objects.
...

You should take a look at Data Binding (which is much more than only binding to data from a dataset) and especially at the interface ICollectionView and the three classes CollectionView, ListCollectionView and BindingListCollectionView. In WPF you don't use a BindingSource-Objekt (and so a CurrencyManager) to manage the currentItem. Instead you use an ICollectionView that manages the currentItem and Position of the Collection it points to.

How to connect wpf with database

Mon, 03 Mar 2008 17:42:39 Z

I highly recommend you take a look at a new technology we released with .NET 3.5 called LINQ to SQL. LINQ stands for "Language Integrated Query", and allows you to write really intuitive code to interface with your database. Here's a link to a short 10-minute video that should be able to help you get up and running.

http://asp.net/learn/videos/video-232.aspx

How to connect wpf with database

Mon, 03 Mar 2008 19:55:55 Z

thankx alot for ur answers
and really thank you for the video