Advertisement
Guest User

Untitled

a guest
Jul 18th, 2018
61
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
C# 0.66 KB | None | 0 0
  1. C#:
  2. [Table("dbo", "User")]
  3. public class User
  4. {
  5.     public string Name { get; set; }
  6.     [Json]
  7.     public IEnumerable<int> Numbers { get; set; }
  8. }
  9.  
  10. public class UserQuery
  11. {
  12.     public int HasNumber { get; set; }
  13. }
  14.  
  15. DDL:
  16. CREATE TABLE [dbo].[User]
  17. (
  18.     Name nvarchar(50),
  19.     Numbers nvarchar(500)
  20. )
  21.  
  22. SQL INSERT:
  23. @model MyProject.Models.User
  24.  
  25. @foreach (var u in this.M.Vals())
  26. {
  27.     INSERT INTO @M.TblName() ( @M.ColNames() ) VALUES ( @M.Pars() )
  28. }
  29.  
  30. SQL QUERY:
  31. @result MyProject.Models.User
  32. @model MyProjection.Models.UserQuery
  33.  
  34. SELECT
  35.     @R.Star()
  36. FROM
  37.     @R.Tbl()
  38. WHERE EXISTS(
  39.     SELECT 0 FROM @R.OpenJson(r => r.Numbers) S1
  40.     WHERE S1.Value = @Model.HasNumber
  41. )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement