If so, any tips or sample code available in this process....
Thanks, Burl
27 Answers, 1 is accepted
It definitely can. We will work on an example but it might take some time.
All the best,
Jan Blessenohl
the Telerik team
Check out Telerik Trainer, the state of the art learning tool for Telerik products.
Rank 2
Thanks, Burl
We will try to cook up something for you next week. Hope that helps.
All the best,
Dimitar Kapitanov
the Telerik team
Check out Telerik Trainer, the state of the art learning tool for Telerik products.
Rank 2
I've been reading the manual but so much of it is out of context as far as the code snippets go that it's hard to grasp using this in a Dnn application. I like using Dnn so I can spend more time focused on adding functionally with new modules and less time building the plumbing for the web site's.
Any additional links for reading material on OpenAccess?
Thanks for the Update!
Burl
Sorry for the late reply. We are in the middle of preparing additional resources like blog posts, KnowledgeBase articles and white papers on the OpenAccess products. I am still evaluating the way of using OpenAccess with DotNetNuke, but I can tell you, it is possible and as far as I see the built in DAL capabilities inside DNN, OpenAccess will be a great enhancement to yuor experience. I am few days away from publishing an KB on the matter so I will let you know asap. If you have any other ideas about how to solve real case problems with OpenAccess, please do share them with us.
Greetings,
Dimitar Kapitanov
the Telerik team
Check out Telerik Trainer, the state of the art learning tool for Telerik products.
Rank 2
Hi Dimitar,
Really looking forward on how to use OpenAccess in Dnn. I'm trying out things but can't really get things going.
Questions:
1. Can open OpenAccess be configured to use the Dnn web.config file to get the database connection(SiteSqlServer element)? It seems that OpenAccess creates it's own app/web config information and additional configuration files, so how and where would these added to either a WSP or WAP module structure?
2. Brandon Haynes has released a LinqToSql model adapter(http://www.codeplex.com/DNNLinqToSqlAdapter) for the Dnn framework that takes into account the runtime-configured "database owner" and "object qualifier". Currently I'm using LinqToSql in my modules for this reason. Would OpenAccess be able to handle something like this as well?
Not a big issue for me as I develop for clients that don't use that feature and I also have full control of the server but could be a show stopper for others.
3. How much of the Dnn database would be included in the ORM in a Dnn Module? I have limited knowledge of this subject for sure! My module has a relationship with the Dnn Users table so information can be removed when the user is deleted.
Standalone applications and basic samples help with understanding the process, but integration into something like Dnn or even SiteFinity I'm sure will bring up many more questions and issues.
Again,
Thanks for keeping us updated and hope I can contribute to the process.
Regards, Burl
Hi Burl,
1. At present Open Access requires its own .config file. For the next major release we are considering to be able to "enhance" websites and use the standard .config files from the sites. If a standard connection is defined within the .config file, we will be able to use it.
2. We didn’t know about this project so far. What I can promise is that we will look into it, and evaluate it for possible OpenAccess implementation. That said our example that we are preparing is based on LINQ queries as a standard way of getting the data, because OpenAccess supports LINQ out of the box. So stay tuned on this one.
3.Could you elaborate a bit more on this topic? What do you mean with "including the DNN database in a module"? We will try to provide not a one-fits-all solution, but rather a learning material on how to use OA with DNN - possibly a simple e-commerce example or similar. At least those are our plans for the near future. Should we consider other approach?
Regarding the integration you are absolutely right! Always the integration into complex systems that follow certain architecture, practices and design is a challenging task. What I am able to share is that we've started Sitefinity integration with OA already. However I am unable to give you exact time-frame on this one.
Regards,
the Telerik team
Check out Telerik Trainer, the state of the art learning tool for Telerik products.
Rank 1
Will OpenAccess be able to gracefully handle DNN's "databaseowner" and "objectqualifier" settings?
Thanks,
Horacio.-
This is open for discussions. We have strong commitment towards supporting DNN and I will add this feature to our TODO list. However at present I'm unable to provide you with an exact time-frame.
Regards,
Dimitar Kapitanov
the Telerik team
Check out Telerik Trainer, the state of the art learning tool for Telerik products.
Rank 2
How's the sample Dnn module with OpenAccess coming? Hope to see something soon.
Thanks, Burl
We are doing some refactoring to our datasource, to allow seamless integration into a DNN module. When we are ready we will provide you with an example asap. At the moment the development of the example is postponed, because it requires some additional functionallity from our datasource.
All the best,
Dimitar Kapitanov
the Telerik team
Check out Telerik Trainer, the state of the art learning tool for Telerik products.
Rank 2
Thanks for the update Dimitar,
Happy to hear about the progress with intergrating OpenAccess with Dnn.
Burl
We will notify you asap, when we achieve our milestones for this development.
Regards,
Dimitar Kapitanov
the Telerik team
Check out Telerik Trainer, the state of the art learning tool for Telerik products.
Rank 1
We can assure you that OpenAccess integration with Dnn will be demonstrated soon after our release on March 10th.
Thank you for you patience.
All the best,
Zoran
the Telerik team
Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.
Rank 1
Would be great to see an example of best practice for Donetnuke development as per the BestParcticeSample provided in the Knowledgebase. Especially due to the fact that DotNetNuke does not employ the use of Masterpages. How should we best handle ObjectScope in DotNetNuke?
Do you have a timeframe for these examples?
Many Thanks
Mark
Rank 1
We made a sample DotNetNuke module based on OpenAccess which you can download from our code-library in C# or VB .NET version. Documentation on our DotnetNuke integration will be available soon as well as some best-practices.
Sincerely yours,
Zoran
the Telerik team
Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.
Rank 1
I'm looking forward to the documentation.
Many thanks again.
Mark
Rank 1
- Can OpenAccess be used in DNN (using the connectionstring in web.config) is there maybe an adapter like the one for the entity framework?
- Where can I find the documentation that is referenced in previous reply?
Thank you.
Yes, OpenAccess is able to be used and integrated in DotNetNuke modules. Here is a link to the mentioned documentation article where you can find more detailed instructions for a sample implementation.
Best wishes,
Zoran
the Telerik team
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.
Rank 1
Sorry. I should have mentioned I had already found that article. My question is how OpenAccess could be configured to use the SiteSQL querystring of the DNN site so a distributable DNN module can be created. If I am not mistaken when using OpenAccess a querystring is created that manually has to be added to the web.config. There are adapters available for DNN for Linq to SQL(http://www.codeplex.com/DNNLinqToSqlAdapter) and the Entity framework(http://dnnentityframework.codeplex.com/) so objectqualifier and database owner configured in DNN are used. I would like to know if something like that is also available for OpenAccess and how I can configure it to use the SQL querystring of the active DNN website.
Hope you can point me in the right direction.
Thank you.
Stephan
Unfortunately we do not provide such a support for the moment. It is on our list, but since we are heavily changing Telerik OpenAccess ORM at the moment, the development of such a resolver is postponed. We will try to push such a development right after the Q1 release.
Greetings,
Dimitar Kapitanov
the Telerik team
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.
Rank 1
It's been about a year since this last post. Has there been any additional movement in supporting {databaseOwner} and {objectQualifier} in DNN? I'm a commercial DNN module developer and seriously looking at ORM's for DNN right now and would love to use OpenAccess because of Telerik's support for DNN.
Unfortunately we were unable to do the required development until now. Our current goals are to stabilize the main APIs we have instead of adding new. Currently I envision the Fluent API and the visual designer. After we achieve those goals we will evaluate how to support the DotNetNuke in a better way.
Best wishes,
Dimitar Kapitanov
the Telerik team
Rank 2
Hi Rutger,
I am afraid that we do not plan improvements in support for DotNetNuke for the next release of the product.I am sorry for the inconvenience caused.
Kind regards,
Damyan Bogoev
the Telerik team