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=Nfirstname.lastname@example.org', @2=N'Test2',
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?