Home Create Umbraco Member using T-SQL
Reply: 0

Create Umbraco Member using T-SQL

user879
1#
user879 Published in April 24, 2018, 10:31 am

I'm trying to create an Umbraco Member using a SQL Server stored procedure instead of the GUI.

Using the SQL Server Profiler I can see that there is a function I can use:

exec sp_executesql N'INSERT INTO [cmsMember] ([nodeId],[Email],[LoginName],[Password]) VALUES (@0,@1,@2,@3)',
                   N'@0 int,@1 nvarchar(4000),@2 nvarchar(4000),@3 nvarchar(4000)',
                   @0=1052, @1=N'test2@email.nl', @2=N'Test2',
                   @3=N'HMMB0498bIiVQ+EoO3ywJQ==6TdcRwNTt/MqaxS1O/ZiQ3906Vd3GcVfgiNHGFWBiTw='

Except the nodeId is not unique. Because a member is linked to a node.

I already created a stored procedure to create an Umbraco user and it just needed 2 inserts queries. But it seems like that an Umbraco member needs 10 inserts.

Is it even possible to create a member this way?

You need to login account before you can post.

About| Privacy statement| Terms of Service| Advertising| Contact us| Help| Sitemap|
Processed in 0.368617 second(s) , Gzip On .

© 2016 Powered by mzan.com design MATCHINFO