How do change this into linq

Question

1.00/5 (3 votes)

See more:

How do I change this SQL insert code to LINQ?

SQL

INSERT INTO dbo.aspnet_UsersInRoles (UserId, RoleId)
    SELECT UserId, RoleId
    FROM @tbUsers, @tbRoles

linqtosql entity framework sorry did not mention earlier.

Posted 12-Mar-12 3:58am

postonoh

Updated 12-Mar-12 4:14am

v2

Add a Solution

Comments

Dean Oliver 12-Mar-12 10:06am

is this linqtosql or entity framework you want to use in your project?

postonoh 12-Mar-12 10:12am

Yes! sorrow I did not mention this.

Dean Oliver 12-Mar-12 10:13am

so which is it?

postonoh 12-Mar-12 10:31am

I created a custom role provider for forms security. I have the following three tables. User, User_In_Role, and Roles. I need for when a user register. It places the into the default group of new user. I submitted this question I believe I had the fix but did not work. I believe with the aspnetdb.net security sproc this is the key to making sure the new user set properly.

My original question is here:
http://www.codeproject.com/Questions/343705/How-set-a-default-role-with-custom-RoleProvider

Dean Oliver 13-Mar-12 1:11am

Please place this comment in your question. And linqtosql and entity framework are two different technologies.

postonoh 16-Mar-12 11:31am

I figure it out thanks for you help. The problem was, I was not making sure the ID for each pk,fk was set.

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Shahin Khorshidnia · Accepted Answer · 2012-03-12T04:01:00

Solution 1

You can change SQL to Linq. Use this tool:

http://www.sqltolinq.com/[^]

Posted 12-Mar-12 4:01am

Shahin Khorshidnia

Updated 12-Mar-12 4:02am

v2

postonoh · Accepted Answer · 2012-04-19T04:06:00

C#

public override void AddUsersToRoles(string[] usernames, string[] roleNames)
         {
              string[] allRoles = GetAllRoles();

              IEnumerable<string> roles = allRoles.Intersect(roleNames);

              if(roles.Any())
              {
                   //RemoveUsersFromRoles(usernames, roleNames);

                   using (var db = new EEGScreeningEntities())
                   {
                        List<int> mlist = (from m in db.aspnet_Users
                                           where usernames.Contains(m.UserName)
                                           select m.UserId).ToList();


                        List<int> glist = (from g in db.aspnet_Roles
                                           where roleNames.Contains(g.RoleName)
                                           select g.RoleId).ToList();


                       var mglist = (from m in mlist from g in glist select new User_In_Roles {UserId = m, RoleId = g }).FirstOrDefault();
                        db.User_In_Roles.AddObject(mglist);

                       db.SaveChanges();

                    }

              }</int></int></string>

is there to condense this.