How to get Ids of inserted data in NPoco?

Question

I have a SQL script that when run, inserts rows in 2 tables. How can I access the Ids of newly inserted rows in Npoco. Here is what my SQL looks like:

DECLARE @@clientId TABLE (Id INT);

INSERT [dbo].[Clients] ([FirstName], [LastName])
OUTPUT INSERTED.clientId INTO @@clientId 
VALUES ( N'John', N'Doe');

SELECT Id FROM @@clientId;

How can I access the selected data in last line, in NPoco using C# ?

score 2 · Answer 1 · answered Jul 17 '18 at 07:09

2

It should auto updated in client object. I have worked in Nhibernate and EF. It should work for NPoco as well.

    public void AddClient(Client client)  
    {  
        connection.Insert<Client>(client);
        //after save client.Id.


    }

answered Jul 17 '18 at 07:09

Deepak Kumar

648
6
14

I am not using Insert method from NPoco as I have a custom script to run. – Farooq Hanif Jul 17 '18 at 07:27

score 0 · Answer 2 · answered Jul 23 '18 at 12:29

0

How are you running the script with NPoco? Maybe something like this?

var RC = Database.Fetch<List<int>>(SQL);

answered Jul 23 '18 at 12:29

JAZ

1,050
6
15

How to get Ids of inserted data in NPoco?

2 Answers2