Recently I was asked to make a WinForm application I was working on secure using CAS (Code Access Security). Specifically they wanted function calls to be secured based on the users domain groups. The intention was to add several different groups to each user that had access to the application and restrict access to certain functionality depending on which role they were assigned. The expectation was that CAS would make this more secure that just disabling menus and buttons.
The final 4 tutorials for the OfficeTest General Tests sample are now available.
The starter page and code can be found here: Firebird and .NET 2.0 development Example.
The tutorials can be found here: JobPosition: Custom Business/DataAccess objects which uses ObjectDataSource with custom made business classes instead of datasets.
and here: Employee: Custom Business/DataAccess objects which uses ObjectDataSource with custom made business classes instead of datasets.
The 14th page of the OfficeTest General Tests tutorial looks again at using ObjectDataSource and custom made business objects. This time we'll look at one method of using sub-class properties to handle foreign key relationships. If you want to review the other tutorials, the central page can be found here Firebird and .NET 2.0 development Example.
The 13th page of the OfficeTest General Tests tutorial looks again at using ObjectDataSource and custom made business objects. This time we'll look at one method of using sub-class properties to handle foreign key relationships. If you want to review the other tutorials, the central page can be found here Firebird and .NET 2.0 development Example.
The 12th page of the OfficeTest General Tests tutorial looks again at using ObjectDataSource and custom made business objects. This time with a slightly more complex example. If you want to review the other tutorials, the central page can be found here Firebird and .NET 2.0 development Example.
The 11th page of the OfficeTest General Tests tutorial looks again at using ObjectDataSource but with custom made business objects this time around. If you want to review the other tutorials, the central page can be found here Firebird and .NET 2.0 development Example.
Someone was asking why the current Firebird MemberShip/Role/Profile Example doesn't work with the ASP.NET Configuration tool for security.
If you look at the scripts or the Firebird database I provided in that example and compare it to the aspnetdb.mdf SqlServer uses, you'll notice a lot of missing procedures and possibly some differences in the table structures. The Firebird scripts were designed to handle the bare minimum needed to make security work for your application, not necessarily for the Visual Studio Management tool.
A poster was nice enough to point out that there was a typo in the FirebirdClientDDEX with Visual Studio 2005 article I posted a while back. I've fixed the typo and described it below in this story. It was a misplaced quote in the machine.config. The end result of the mistake seems to cause the Firebird connection dialog to disappear when you type or press any buttons.
Here is the change:
The 7th to 10th tutorial pages for the OfficeTest General Tests sample is now available.
The starter page and code can be found here: Firebird and .NET 2.0 development Example.
The tutorials can be found here: Employee: Select Procedure web page which calls a stored procedure with a result set directly and through a select SQL query.
and here: Stored Procedure web page which calls a stored procedure with no result set and retrieves a computed value.
The 10th page of the OfficeTest General Tests tutorial looks again at using Strongly Typed DataSets and ObjectDataSource in place of SqlDataSource. This time however we will review a slightly more complex example. If you want to review the other tutorials, the central page can be found here Firebird and .NET 2.0 development Example.