This is my first crack at Umbraco and the site I am doing will require a lot of sql server database access and I have gotten rather used to the strongly typed datasets that you can generate in web application projects in Visual studio
Plugging away at this I finally cracked it but I would like to know if there are others out there who are doing things in the same way.
Basically I am building an asp.net control which may have a gridview or a repeater in it and using strongly typed datasets and table adapters to access the db.
When building the project, I copy across all the ascx and associated files to the umbraco web site along with the xsd and xss files to the app_code folder (all using Post build events in VS2008). This works a treat!
I guess I want some reassurance that I am not blaspheming in any way and that this is a valid way to work with databases in Umbraco.
Current version of umbraco support multiple databases - mssql, vistadb and mysql using datalayer. You should use it too if you can create package which work on these databases. If you want support only mssql, you can generate typed datasets and use it if you wish.
IMHO you should use nhibernate, entityframework, linq2sql or subsonic, typed datasets are obsolete.
DB Access and Strongly Typed datasets in Umbraco
This is my first crack at Umbraco and the site I am doing will require a lot of sql server database access and I have gotten rather used to the strongly typed datasets that you can generate in web application projects in Visual studio
Plugging away at this I finally cracked it but I would like to know if there are others out there who are doing things in the same way.
Basically I am building an asp.net control which may have a gridview or a repeater in it and using strongly typed datasets and table adapters to access the db.
When building the project, I copy across all the ascx and associated files to the umbraco web site along with the xsd and xss files to the app_code folder (all using Post build events in VS2008). This works a treat!
I guess I want some reassurance that I am not blaspheming in any way and that this is a valid way to work with databases in Umbraco.
Very interested to hear comments
Thanks
Julian
Current version of umbraco support multiple databases - mssql, vistadb and mysql using datalayer. You should use it too if you can create package which work on these databases. If you want support only mssql, you can generate typed datasets and use it if you wish.
IMHO you should use nhibernate, entityframework, linq2sql or subsonic, typed datasets are obsolete.
Petr
is working on a reply...
This forum is in read-only mode while we transition to the new forum.
You can continue this topic on the new forum by tapping the "Continue discussion" link below.