C# - Overriding SQLMembershipProvider / Adding Few Extra Methods To Deal With The Roles By Using LINQ?

May 27, 2010

Is there built in methods into .net framework to do the following:

Get role GUID from user name/user GUID
Get role name from role GUID

So far I have been sending queries to the asp_roles and asp_users tables to obtain that information and I'm wondering if there is a nicer way of doing this?

I have the following methods that I store in the ASPUtilities class:

getRoleGUID(guid userGuid) { LINQ joins }

getRoleGuid(string userName) { LINQ joins }

getRoleName(guid roleGuid) { LINQ joins }

EDIT:

I have just looked into extending SQLMembershipProvider examples.

Few examples completely override the SQLMembershipProvider, but I think what I'm interested is just adding few extra methods to deal with the roles by using LINQ. Is this feasible?

View 1 Replies


Similar Messages:

.net - Use Custom SqlMembershipProvider To Store Users (and Roles) In Cache?

Feb 15, 2011

i'm developing a "small" warehouse-management WebApplication for few users(5-10 parralel) but with a complex authorization system(checking if pages,menus,TabPanels, UserControls and even single controls are visible or enabled) and permanent and frequent access. Because i've only limited experiences with the ASP.Net MembershipProvider, i'm unsure what's the best approach for following goal:

I want to hold all users, roles and frequently used masterdata in the Cache(in a Dataset). Hence every readonly access should be faster and causes less traffic than always using the database. On updates,deletes and inserts i would update the cached dataset and also the database.Can i use or extend the SqlMembershipProvider to achieve this goal and if possible how?Should i use the stored-procedures from asp.net or simply use the standard CreateUser, GetUser, DeleteUser-functionality? Does this approach makes sense at all?

View 1 Replies

Security :: Adding SqlMembershipProvider Schema To A Database?

Aug 7, 2010

I'm currently creating a small web app that requires users to log in before accessing any features.

I'm using Visual Web Developer 2010 and I have created a database in the App_Data folder of my project that I now wish to add the required tables, views and stored procedures to in order to use the SqlMembershipProvider. I have ran the aspnet_regsql file and entered the required details and completed all the required steps; however, when I return to Visual Web Developer and refresh the database I created, nothing happens, there are no tables or stored procedures.

Although nothing has been added to the database in my project, when I open up SQL Server Management Studio, my database appears with all the relevant tables, views etc.

Is there any reason why the database with all the required tables etc appears in SQL Server Management Studio but not in my project in Visual Web Developer?

I'm getting rather confused as I have completed this before on another project on a different machine and it worked fine.

View 2 Replies

ADO.NET :: Deal With Linq To Sql Like Dataset

Mar 8, 2011

ite on dataset model and I used to write sql quires into dataset and call them with in my c# code as usual. and used the datatablein c#code to access the values of each column which corresponds to a sql column in the sql table. after a while I found my website going on too slowso I decided to use linq to sql classes. i can write queries in c# code

[Code]....

View 4 Replies

Adding An Extra Column In A Datatable

Jun 21, 2010

How do you add an extra column in a datatable which will be used for another query

View 3 Replies

Web Forms :: Adding Extra Option In DropDown Of Webform?

Nov 6, 2010

how to setup a edit option in the drop down...

Example:

I have a drop down for 6 colors...and user didn't find the color which he wants...can I place a last option as new or Edit or something which allows the user to enter the color he wants in the dropdown or change that drop down to textbox to enter data... If this is possibly then how can i capture those values in the code behind...

View 3 Replies

How To Add One Extra Temporary Entity In Collection Returned By LINQ

Nov 23, 2010

here my code-

List<ReservationSlotLimitDetailEntity> sorted = (from p in slotLimitCollection.OfType<ReservationSlotLimitDetailEntity>()
where p.DayOfTheWeek == dayOfTheWeek
select p).ToList<ReservationSlotLimitDetailEntity>();

I want to sort in such a way so that it will add on more temp column "DayName" based on condition such that if dayOfTheWeek==1 DayName=Monday and if dayOfTheWeek==2 DayName=Tuesday and so on.

View 1 Replies

VS 2010 Adds Colgroup - IDE Stop Adding Extra Elements?

Jan 20, 2011

I have a code like the following:

Code:
<table>
<col width="50%" />
<col width="50%" />
<tr>
<td>
</td>
<td>
blah blah
</td>
</tr>
</table>

When i switch to design and get back to source view it added the colgroup so my code looks like this:

Code:
<table>
<colgroup>
<col width="50%" />
<col width="50%" />
<tr>
<td>
</td>
<td>
blah blah
</td>
</tr>
</colgroup>
</table>

how to make the IDE stop adding these extra elements? i changed the Target Schema to all possible combination and it didn't help.

View 9 Replies

Forms Data Controls :: Adding Extra Merged Row Or Header?

May 7, 2010

i want to add an extra header to my grid.. i want to do the following..

[Code]....

knowing that the data source of this grid is dataset

View 8 Replies

DataSource Controls :: LINQ To SQL Add's Extra Precision To DateTime - Causing Error

Apr 26, 2010

I am having an issue when trying to update a ModifiedDateColumn in the database via LINQ. I am setting the ModifiedDate property (which is a DateTime in both SQL Server and my code) using DateTime.Now. I am getting an error where LINQ is generating too many precisions when generating the SQL to execute. Here is what the LINQ is generating (see @p3 & @p5)

[Code]....

How do I get LINQ to only generate to only 3 decimal places?

View 1 Replies

Forms Data Controls :: Adding An Extra Row With A Message In The Bottom Of The Grid View?

Nov 18, 2010

I am facing a problem with grid view footer template.. I just want to add a message like hello world in the bottom of the grid view as a seperate row... Right now I am using footer for this..but If the size of footer text increases the width of column which holds that will also increasing.. Is there any way to add a label in the bottom of the grid like

Ex: The number of Students is 200

This will needs to come in the bottom of grid without changing the size of columns..

View 11 Replies

"GroupBy" And "OrderBy" Methods From LINQ As Extension Methods?

Mar 11, 2010

We say that "GroupBy" and "OrderBy" methods from LINQ as Extension Methods.Then how about "variable.ToString()" and "string.Split()" menthods. Are these Extension methods.

View 2 Replies

Security :: Adding User To Certain Roles?

Aug 24, 2010

I have setup ASP security in my application. I used the following tutorial, just wondering if someone can tell me how i can setup this up to allow the creation of a user?

http://weblogs.asp.net/scottgu/pages/Recipe_3A00_-Implementing-Role_2D00_Based-Security-with-ASP.NET-2.0-using-Windows-Authentication-and-SQL-Server.aspx

where to find or what to search on to find some example of how to add the option for adding users?

I have the above setup and its working, but only because of the accounts i created with my global.asax file.

I need to give the admins access to add a new user. Currently i can search on existing users and update them, but need to add the ability to add a new user.

View 4 Replies

Security :: Adding Domain User Roles To A Web App?

Jun 18, 2010

I want to make my domain administrators the administrators to my web application so that they are the only ones that can change content. All other users would simply be able to read the material. I am relatively new to web apps and I can not seem to find what I am looking for anywhere on the net.

View 2 Replies

.net - Adding Users / Membership And Roles To Site?

Apr 9, 2010

I have followed scott's gu tutorial here I uploaded the whole database to my site. Before doing what Scott's says I had one username stored in the membership. How can I create an additional user now that the table is in the web host? I can see that there's aspnet_Membership, aspnet_Applications, etc..etc

View 2 Replies

Security :: Adding User To Membership And Roles?

May 7, 2010

Its very easy to add users to roles by using the in built controls. but how can add users through customized login controls?. i have tried using

//MembershipUser m = Membership.CreateUser(name, pass, null);

View 3 Replies

Web Forms :: Adding New Methods To System.Web.TraceContext?

Mar 29, 2010

At my work we use Trace.Write() and Trace.Warn() quite extensively. The problem is, sometimes the output can be difficult to read with all of the other default trace info written, so we want to be able to extend that a bit and add new colors, bold versions, etc. I had tried the following, but as I've never tried adding to an existing class, I failed miserably.

[Code]....

View 2 Replies

C# - LINQ Data Context Not Showing Methods?

May 11, 2010

For some reason my DataContext is not showing all the normal methods like SubmitChanges() etc in the intellisense.It also won't compile if I type in db.SubmitChanges();Any idea what I'm doing wrong? Normally I don't have this issue, I have several other projects that work fine...

View 1 Replies

Security :: How To Use Roles Framework Without Adding Its Tables To Database

Jan 19, 2010

i want to implement role_based autherization in an application, the only way i know to do it is to use roles framework, but i don't want to add any extra tables to my database, my database already have a users table with a column that specifies a role for each user

how can i use this framework without adding the tables it requires to my database?

View 2 Replies

How To Split String Adding Extra String When No Data Is There

Nov 12, 2010

I have some code that splits a session into strings by a -

My session looks something like this 123-456-789- and I split it like this

Dim MyString As String() = Session("MySession").Split("-"C)

And i've got a some code like this

Dim x as Integer

For x = 0 to MyString - 1

Response.write("Ref: " & MyString(x) & "<br>")

Next

This writes the code like this

Ref: 123
Ref: 456
Ref: 789
Ref:

So it's adding an extra Ref where it shouldn't be because there is no data after the last -

Is there a way to stop this adding in the extra one?

View 1 Replies

DataSource Controls :: ObjectDataSource Sorting And Paging In Gridview Using LINQ Stored Procedure Methods?

Jan 31, 2010

I started learning LINQ, So i thought of just creating gridview with sorting and paging using objectdatasource using LINQ. So i got this link

[URL] which Brian Orrel tell us how to do using IQueryable Interface. but i have nearly 300 lines of stored procedure which joins nearly 20 tables. so i thought of creating a stored procedure and using that instead of IQuerytable.

[code]...

View 7 Replies

SQL Server :: "Adding Parameterized Methods To The Data Access Layer"?

Sep 6, 2010

em all new in C# and .NET.I am following this tutorial: [URL]And i am at step 3: Adding Parameterized Methods to the Data Access Layer - i have No problems in getting out all information from my database.But when i try to get a specific item by CategoryID i get a Error.This is what i type in my Query in the table adapter:

SELECT ProductID, ProductName, SupplierID, CategoryID, QuantityPerUnit, UnitPrice, UnitsInStock, UnitsOnOrder, ReorderLevel, Discontinued
FROM Products
WHERE CategoryID = @CategoryID

Here is the error i get when i click finish:The wizard detected the following problems when configuring TableAdapter Query "FillByCategoryID":

Details:
Generated SELECT statement.
Error in WHERE clause near '@'.
Unable to parse query text.

View 7 Replies

Security :: Upgrade To SqlMembershipProvider?

Sep 7, 2010

I've been given the task to update an existing website. Currently the website has a login only for administrators. They administer everything on the site, including all "Artist" data. This is done using simple form authentication and custom user table. Right now the "users" table only has one record since all administrators use the same username/password (not good, I know). As the "new" developer, I've been asked to update this site to allow the "Artists" to register themselves, and be able to update their own information. Ideally I want to get rid of all the current security, and use the SqlMembershipProvider. My issue? I have the database added to my schema, but I'm assuming something else within the site is confused. When I try and use the ASP.NET I get an error: "Configured settings are invalid: Hashed passwords cannot be retrieved. Either set the password format to different type, or set supportsPasswordRetrieval to false.(C:Inetpubwwwrootsitessite1web.config line 21)

Right now there are no users, no applicatins even set up in the sQLMembershipProvider tables. I've been following the MSDN site, as well as some secuity tutorials on this site (ASP.NET), but none of the solutions suggested works for me. I've created a "Register.aspx"
page, and when I load it I get this error: "Configured settings are invalid: Hashed passwords cannot be retrieved. Either set the password format to different type, or set supportsPasswordRetrieval to false."

Here's part of my web.conf file:

[Code]....

View 2 Replies

ADO.NET :: Adding Data To Table Using Linq To Sql?

Oct 31, 2010

i am choosing a category from a DropDownList controll, and if want to add a new category at the same time i have a TextBoks for it, i have create a Model, BLL and DAL classes, my problem is:

in the DAL class i want to add a new row to Question, but i need to check first if the object.category exsist in the table Category, if it does i want to get the Cid for it if it dosen't exist i want to create a new raw then get the Cid, this is my code:

public string add(Faq inFaq)
{
using (var db = new DBClassDataContext())
{
try
{
var se = from Category in db.Categorys
where Category.category == inFaq.category
select Category.Cid;
if (se.Count() == 0 ).........

View 4 Replies

How To Make All Of The Roles Defined In RoleGroup> Required? (i.e. User Must Meet All Roles)

Feb 24, 2011

Let's say I have a rolegroup as follows:

<asp:LoginView ID="lvDoSomeStuff" runat="server">
<RoleGroups>
<asp:RoleGroup Roles="RoleOne,RoleTwo">
<ContentTemplate>
...
</ContentTemplate>
</asp:RoleGroup>
</RoleGroups>
</asp:LoginView>

Is there a way I can make it so that a user must meet RoleOne and RoleTwo to satisfy the RoleGroup? By default, if a user is in either of the two roles, they will be granted access. I know I can do this via the code-behind, but I'd prefer to be able to wrap some content template with this markup instead of having to wrap it in a panel and hide the panel programmatically.

View 1 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved