This is a migrated thread and some comments may be shown as answers.
Dynamic Data and Open Access
18 Answers 225 Views
This is a migrated thread and some comments may be shown as answers.
This question is locked. New answers and comments are not allowed.
Gavin
Top achievements
Rank 1
Gavin asked on 11 Oct 2009, 11:45 PM
Hi there,

Please will you provide some guidance on how to use Open Access with Microsoft's Dynamic Data. A sample project would be great!

Many thanks.

Gavin

18 Answers, 1 is accepted

Sort by
0
Zoran
Telerik team
answered on 14 Oct 2009, 03:17 PM
Hello Gavin,

Telerik OpenAccess ORM team is already developing in the direction of integration our product with Dynamic Data features. The IUpdatable interface required by the framework is implemented in our Data Context class which you can find in the Telerik.OpenAccess.40 assembly. We would appreciate if you could give us some suggestions/requirements about the functionality that you would like to see implemented in the future. Also I must assure you that our Telerik Data Wizard will support DynamicData development in one of the releases to come.

Regards,
Zoran
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.
0
Erik
Top achievements
Rank 2
answered on 29 Mar 2011, 08:06 PM
Hi Zoran,

Am I missing a thread or is it not available:

Is it possible to use open access as a context provider for a Dynamic Data (entities) Web Application? 

Regards,

Erik
0
Damyan Bogoev
Telerik team
answered on 30 Mar 2011, 07:45 PM
Hello Proovit,

Yes, you could use the Telerik OpenAccess ORM with Dynamic Data. We prepared examples which demonstrate this functionality. The examples are shipped with the Telerik OpenAccess SDK Browser.
Hope that helps.

Best wishes,
Damyan Bogoev
the Telerik team
0
Erik
Top achievements
Rank 2
answered on 31 Mar 2011, 12:06 PM
Thanks Damyan,

That was all I need! had some problems with the browser because of an installing issue (I installed on E:, but ORMthen installes some on C: and some on E: and the browser does not work. Posted that in a ticket already.)

Thanks,

Erik
0
Damyan Bogoev
Telerik team
answered on 31 Mar 2011, 10:24 PM
Hi Proovit,

Firstly I want to thank you for the valuable input.
We will investigate the cause for this issue and fix it. Currently we are working on the next version of the Product SDK.
You could find your Telerik points updated.

Regards,
Damyan Bogoev
the Telerik team
0
okan
Top achievements
Rank 1
answered on 18 May 2011, 09:59 AM
Hi,
is there any sample where we can use both OpenAccess ORM and ASP.net Ajax controls together.
OpenAccess  sdk contains dynamicdata sample and I found some code samples from telerik blogs where they replace aspgrid and some other editor controls. But I couldn't merge those samples together.

Regards
Okan
0
Erik
Top achievements
Rank 2
answered on 18 May 2011, 11:26 AM
Yes, was thinking about that to Okan.
0
Damyan Bogoev
Telerik team
answered on 19 May 2011, 05:30 PM
Hello Erik,

@Okan: Yes, there are samples that use both Telerik OpenAccess ORM and ASP.NET AJAX controls. You could look at the examples under the ASP category.
Hope you will find them useful.

Kind regards,
Damyan Bogoev
the Telerik team
Q1’11 SP1 of Telerik OpenAccess is available for download; also available is the Q2'11 Roadmap for Telerik OpenAccess ORM.
0
okan
Top achievements
Rank 1
answered on 20 May 2011, 10:27 AM
Hi Damyan,
I think I couldn't make myself clear
Is there any dynamic data sample where we can use both OpenAccess ORM and ASP.net Ajax controls (RadGrid,etc.) together?Becasue I could'nt find any dynamic data sample in SDK which contains both orm and for example radgrid.

I tried to make dynamicdata web site by combining OpenAccess ORM and ASP.net Ajax samples that I found on the telerik forums and blogs. I managed to display orm datasource's data in rad-grid in a dynamicdata web site.

But there are some minor problems like:CRUD operations is not working :) But i can say that at least my project looks better than standart Visual Studio dynamic data website thanks to Telerik Radgrid. You can find modified partition of DynamicRadGrid.cs below. But my project needs  more work. In the mean time I would be happy to see openaccess q2 2011 coming with dynamicdata support.




DynamicRadGrid.cs
protected override void OnInit(EventArgs e){
           base.OnInit(e);
 
           AllowAutomaticUpdates = true;
           AllowAutomaticDeletes = true;
 
           MetaTable metaTable = this.FindMetaTable();
 
           List<string> list = new List<string>();
           foreach (MetaColumn column in metaTable.PrimaryKeyColumns)
           {
               list.Add(column.Name);
           }
           MasterTableView.DataKeyNames = list.ToArray();
 
           foreach (MetaColumn column in metaTable.Columns)
           {
               if (!column.Scaffold || column.IsLongString )
               {
                   continue;
               }
               if (column is MetaForeignKeyColumn)
               {
                   GridHyperLinkColumn link = new GridHyperLinkColumn();
                   link.DataNavigateUrlFormatString = "~/" + ((MetaForeignKeyColumn)column).ParentTable.Name + "/ListDetails.aspx?" + metaTable.PrimaryKeyColumns[0].Name + "={0}";
                   string[] navigateFields = new string[] { metaTable.PrimaryKeyColumns[0].Name };
 
                   link.DataNavigateUrlFields = navigateFields;
                   link.DataTextField = column.Name;
 
                   link.HeaderText = column.DisplayName;
                   MasterTableView.Columns.Add(link);
               }
               else if (column.GetType().FullName == "System.Web.DynamicData.MetaChildrenColumn")
               {
                   GridHyperLinkColumn link = new GridHyperLinkColumn();
                   link.DataNavigateUrlFormatString = "~/" + ((MetaChildrenColumn)column).ChildTable.Name + "/ListDetails.aspx?" + metaTable.PrimaryKeyColumns[0].Name + "={0}";
                   string[] navigateFields = new string[] { metaTable.PrimaryKeyColumns[0].Name };
 
                   link.DataNavigateUrlFields = navigateFields;
                   link.DataTextField = column.Name;
 
                   link.HeaderText = column.DisplayName;
                   MasterTableView.Columns.Add(link);
               }
               else
               {
                   DynamicGridBoundColumn gridColumn = new DynamicGridBoundColumn();
 
                   gridColumn.DataField = column.Name;
                   gridColumn.ConvertEmptyStringToNull = column.ConvertEmptyStringToNull;
                   gridColumn.DataFormatString = column.DataFormatString;
                   gridColumn.UIHint = column.UIHint;
                   gridColumn.HtmlEncode = column.HtmlEncode;
                   gridColumn.NullDisplayText = column.NullDisplayText;
                   gridColumn.ApplyFormatInEditMode = column.ApplyFormatInEditMode;
                   gridColumn.HeaderText = column.DisplayName;
 
                   MasterTableView.Columns.Add(gridColumn);
               }
 
           }
0
Damyan Bogoev
Telerik team
answered on 25 May 2011, 05:33 PM
Hi Erik,

We will prepare a sample application that uses RadGrid with Telerik OpenAccess ORM and Dynamic Data. Once we implement it we will provide it to you.
I am sorry for the inconvenience caused.

Greetings,
Damyan Bogoev
the Telerik team
Q1’11 SP1 of Telerik OpenAccess is available for download; also available is the Q2'11 Roadmap for Telerik OpenAccess ORM.
0
Erik
Top achievements
Rank 2
answered on 07 Jun 2011, 10:25 AM
Looking forward to that.... and so is Okan I believe... 
:-)
0
okan
Top achievements
Rank 1
answered on 07 Jun 2011, 12:59 PM
After trying to figure out a way to combine examples for several hours I gave up  and started to wait for working example from Telerik :))
Edit: Is there any chance that we can get nightly build for open access ORM SDK?
0
Damyan Bogoev
Telerik team
answered on 13 Jun 2011, 09:40 AM
Hello okan,

You could find the following blog post useful. It demonstrates how to use RadGrid with Dynamic Data.
We will do our best to include the example in the next release of the Product SDK.
Hope that helps.

Greetings,
Damyan Bogoev
the Telerik team
Q1’11 SP1 of Telerik OpenAccess is available for download; also available is the Q2'11 Roadmap for Telerik OpenAccess ORM.
0
okan
Top achievements
Rank 1
answered on 20 Jun 2011, 08:38 AM
Hello Damyan,
When I click the link I get server error
http://blogs.telerik.com/Server-Error.aspx?aspxerrorpath=/sitefinity/cmsentrypoint.aspx
0
Damyan Bogoev
Telerik team
answered on 20 Jun 2011, 03:05 PM
Hello okan,

Firstly I want to apologize for the inconvenience caused.
It seems that the blog post’s Uri was changed. Now you could find it here.

Greetings,
Damyan Bogoev
the Telerik team
Q1’11 SP1 of Telerik OpenAccess is available for download; also available is the Q2'11 Roadmap for Telerik OpenAccess ORM.
0
Ajay
Top achievements
Rank 1
answered on 20 Jun 2011, 04:29 PM
I am new to Telerik ORM
Which scaffolding tool Do you recommend?
0
okan
Top achievements
Rank 1
answered on 21 Jun 2011, 08:42 AM
Thank you Damyan
This really helps and I am looking forward to updated open access sdk dynamic data examples you mentioned earlier.

Regards.
Okan
0
Damyan Bogoev
Telerik team
answered on 22 Jun 2011, 05:08 PM
Hi Ajay,

I am afraid that we do not provide such scaffolding tool.
Actually you could implement partial classes to provide metadata information for each of the persistent capable classes that you want to use:

[MetadataType(typeof(ProductsMetadata))]
public partial class Products
{
    [TableName("Products")]
    public class ProductsMetadata
    {
        [ScaffoldColumn(false)]
        public object ProductID { get; set; }
 
        [DisplayName("Product Name")]
        public object ProductName { get; set; }
 
        [DisplayName("Price"),DisplayFormat(DataFormatString = "{0:c}")]
        public object UnitPrice { get; set; }
 
        [DisplayName("Stock")]
        public object UnitsInStock { get; set; }
 
        [ScaffoldColumn(false)]
        public object ReorderLevel { get; set; }
 
        [ScaffoldColumn(false)]
        public object Discontinued { get; set; }
 
        [ScaffoldColumn(false)]
        public object QuantityPerUnit { get; set; }
 
        [ScaffoldColumn(false)]
        public object UnitsOnOrder { get; set; }
 
        [ScaffoldColumn(false)]
        public object Suppliers { get; set; }
 
        [ScaffoldColumn(false)]
        public object OrderDetails { get; set; }
    }
}

Hope that helps.

Regards,
Damyan Bogoev
the Telerik team
Q1’11 SP1 of Telerik OpenAccess is available for download; also available is the Q2'11 Roadmap for Telerik OpenAccess ORM.
Tags
Integration with other products
Asked by
Gavin
Top achievements
Rank 1
Answers by
Zoran
Telerik team
Erik
Top achievements
Rank 2
Damyan Bogoev
Telerik team
okan
Top achievements
Rank 1
Ajay
Top achievements
Rank 1
Share this question
or