Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- C#:
- [Table("dbo", "User")]
- public class User
- {
- public string Name { get; set; }
- [Json]
- public IEnumerable<int> Numbers { get; set; }
- }
- public class UserQuery
- {
- public int HasNumber { get; set; }
- }
- DDL:
- CREATE TABLE [dbo].[User]
- (
- Name nvarchar(50),
- Numbers nvarchar(500)
- )
- SQL INSERT:
- @model MyProject.Models.User
- @foreach (var u in this.M.Vals())
- {
- INSERT INTO @M.TblName() ( @M.ColNames() ) VALUES ( @M.Pars() )
- }
- SQL QUERY:
- @result MyProject.Models.User
- @model MyProjection.Models.UserQuery
- SELECT
- @R.Star()
- FROM
- @R.Tbl()
- WHERE EXISTS(
- SELECT 0 FROM @R.OpenJson(r => r.Numbers) S1
- WHERE S1.Value = @Model.HasNumber
- )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement