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?
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?
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.
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
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...
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.
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?
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..
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.
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?
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.
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.
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
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.
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...
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?
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.
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.
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."
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 ).........
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.