Is there a way in sql 2008 to block a dba's access to user data? I think the capability exists. however I cant seem to find any documentation on it.
View Complete Post
I was rummaging the internet learning aspx and came across the concept of: Microsoft Application Block for Data Access in .NET
It seems great of course. The articles are all early 2003-5 such as
So the question is - is this tech still relevant and should I be using it?
E nterprise applications can have a wide variety of data update requirements. Sometimes you need to save multiple rows of changes at once within a single transaction. Other times, the user must be allowed to enter multiple rows of data, send them to the database in a batch; and if a row or two fails, only the rows that succeeded should be committed and remain committed.
MSDN Magazine October 2005
Last month I explored the foundation of the Enterprise Library Data Access Application Block (DAAB) including how it all fits into an architecture (see Data Points: The Enterprise Library Data Access Application Block, Part 1).
MSDN Magazine August 2005
A solid data access later (DAL) can benefit an application by hiding redundant tasks, helping handle exceptions more gracefully, helping clean up resources more efficiently, and providing a layer of abstraction from the database.
MSDN Magazine July 2005
I'm not sure how to structure the code for this but what I want to do is be able to add data to a database, and once this has completed successfully, then email the user to say the details have been added successfully to the database.
I need to:
1. Check that the relevant data has been added into the database then
2. Email the details of the relevant data when completed.
Thanks in advance for your help,
I'm using the defualt membership provider, i created a table and used the gridview on the logged in user page to show his information such as address e-mail phone zip code etc,, how can i do this without writing a code?
I am new to asp.net i need simple help please?
I'm trying to get the current logged in UserId Value, using this code
Protected Sub UserProfileDataSource_Selecting(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.SqlDataSourceSelectingEventArgs) Handles UserProfileDataSource.Selecting
' Get a reference to the currently logged on user
Dim currentUser As MembershipUser = Membership.GetUser()
' Determine the currently logged on user's UserId value
Dim currentUserId As Guid = CType(currentUser.ProviderUserKey, Guid)
' Assign the currently logged on user's UserId to the @UserId parameter
e.Command.Parameters("@UserId").Value = currentUserId
But, I getting an error (NullReferenceException), I did set a url authorization on the page that i try to get the logged in user information, witch is info.aspx, and I made the login.aspx control to be redirected to the info.aspx after the login process, But the info.aspx only shows me (access in denied), how can i make this page knows that i am already logged in?
Ive just started a project that will use the enterprise library 4.1 data access code blocks. Its been years since ive used them, can anyone tell me what assemblies I need to reference in my project in order to use them ? Ive referenced
are there any others I need ?
I am trying to persist data in a dynamically populated ListBox in a
user control. Here are the details
I have a user control which contains a a listBox and button. On
Page_Load of user control I am populating the ListBox control with some
values. On Click of button, I am trying to fetch the values which I have
selected in ListBox. Though this seems very simple
and straight forward I am unable to fetch values.
My Page_Load Function
void Page_Load(object sender, EventArgs e)
My Click Function
Protected Void Button1_Click(object sender, EventArgs e)
string strValue = listBox.SelectedValue
I have placed brake point at Page_Load and on click function, I am
seeing that the moment the breakpoin
Julie Lerman shows database administrators how to limit access to databases from the Entity Framework by allowing it to work only with views and stored procedures instead of tables-without impacting application code or alienating developers.
MSDN Magazine August 2010
Building an NHibernate-based desktop application isn't any harder than building a web application, and in many cases NHibernate simplifies elements of session handling and concurrency.
MSDN Magazine December 2009
Developers deploy a wide variety of development philosophies and architecture styles. This article explores three common perspectives on application development and describes how the Entity Framework can be employed in each. Specifically, the article looks at the forms-centric, model-centric, and code-centric development styles and their relationship to the Entity Framework.
MSDN Magazine August 2009
In this article, the author delves into some commonly used ways of writing data access code and looks at the effect they can have on performance.
In this article the author looks at two versions of the same application--one consuming an on-premise Data Service, and one consuming an Azure Table Data Service to illustrate data access in the cloud.
MSDN Magazine May 2009
Building a data access layer using LINQ to SQL and the ADO.NET Entity Framework allows you to decouple your application from the persistence technology you're using.
MSDN Magazine December 2008