Dynamic Data Entry with WPF and LINQ

re: Dynamic Data Entry with WPF and LINQ

Gilbert — Fri, 06 Nov 2009 20:53:00 GMT

Hello! Beth Massi. I really appreciate all your efforts for helping us to learn in vb. Actually I'm just new in wpf and the two wpf video series help me a lot to learn on it. May i request if you could upload your video more on wpf same as the previous with 26 video. Many Thanks!!

re: Dynamic Data Entry with WPF and LINQ

Railton — Sat, 02 May 2009 23:32:24 GMT

Hi,

I've just got round to looking at this again. I have managed to get it to work but I had to create a new tableadapter and change the declarations so they included ce for example sqlcedataadapter.

I also found that I get an error on the XamlReader.Load if the column names have a space in them.

Thanks again for your help.

Railton.

re: Dynamic Data Entry with WPF and LINQ

Beth Massi — Mon, 27 Apr 2009 19:47:28 GMT

Hi Railton,

There should only be one reference to the GetTableSchema stored proc. All you need to do is change the query on the TableAdapter on the TableSchema dataset. Just right-click and select Configure and then you can change the query to select from your metadata table instead. For more info on configuring TableAdapter queries: http://msdn.microsoft.com/en-us/library/kda44dwy.aspx

HTH,

-B

re: Dynamic Data Entry with WPF and LINQ

Railton — Sun, 26 Apr 2009 12:32:47 GMT

Hi,

Thanks for the reply, I'm Ok with the concept of storing meta-data in my own tables and retrieving it via sql.

Looking at the code there are quite a few references to the stored procedure and its result set, the area I think I will struggle is converting these references to use the data returned from the SQL.

Hope this makes sense! :)

Railton.

re: Dynamic Data Entry with WPF and LINQ

Beth Massi — Thu, 23 Apr 2009 20:13:09 GMT

Hi Railton,

Just create a table that contains the metadata you need, i.e. TableName, ColumnName, Type, Length, IsPrimaryKey and fill it with the information about each table. Then just query that instead. It's more maintance becuause you need to make sure the schema and the metadata are in sync but it's the easiest approach for SQL Compact.

HTH,

-B

re: Dynamic Data Entry with WPF and LINQ

Railton — Thu, 23 Apr 2009 10:29:43 GMT

Hi,

Thanks for the steer, however I don't think my skill are deep enough to convert your code :(

Thanks again,

Railton

re: Dynamic Data Entry with WPF and LINQ

Beth Massi — Thu, 23 Apr 2009 03:59:16 GMT

Hi Railton,

The only thing that won't work with SQL Compact is the GetTableSchema stored procedure. SQL Compact doesn't support stored procs so you'll need another way to get the metadata, like storing it in another table.

HTH,

-B

re: Dynamic Data Entry with WPF and LINQ

Railton — Thu, 23 Apr 2009 01:59:48 GMT

Ok, thanks.

Quick question. Is it possible to use this technique on the compact edition?

I am writing an application which uses the compact edition database and I need a dynamic UI for editing the table data because columns on the tables will not always be the same and I don't want to have to modify the application each time. Your code did exactly what I need so was hoping I could use it.

Thanks again for your help.

Railton

re: Dynamic Data Entry with WPF and LINQ

Beth Massi — Thu, 23 Apr 2009 01:50:02 GMT

Hi Railton,

Ah, yes. You need SQL Server or the free SQL Server Express edition: http://www.microsoft.com/express/sql/

HTH,

-B

re: Dynamic Data Entry with WPF and LINQ

Railton — Thu, 23 Apr 2009 01:41:14 GMT

Hi Beth,

I tried the download but I am not able to use the NORTHWND.MDF in my environment, I get a similar error to the one I mentioned before when testing the connection. Could this be because I only have SQL Server 2008 Compact Edition installed?

Thanks,

Railton