SELECT Event_Id, Title, Text, [User], Phone, Adress, Free, Category.Name,  Date_Event,  Time_From, Time_To, Views.Views         FROM Events, Category, Date_Events, Rel_Events_Date, Views  WHERE   Event_Id = " + id + " and Events.Category = Category.Category_Id and Events.Event_Id = Rel_Events_Date.Event and Date_Events.Date_Events_Id = Rel_Events_Date.Date_id and Views.Record_id = Events.Event_Id

CREATE TABLE [dbo].[Category] (
  [Category_Id] int IDENTITY(1, 1) NOT NULL,
  [Name] nvarchar(40) COLLATE Cyrillic_General_CI_AS NOT NULL,
  [Parrent_category] int NOT NULL,
  [Is_sub_category] bit NOT NULL,
  [Orders] smallint NULL,
  PRIMARY KEY CLUSTERED ([Category_Id])
)
ON [PRIMARY]
GO

EXEC sp_addextendedproperty 'MS_Description', N'сортировка', N'schema', N'dbo', N'table', N'Category', N'column', N'Orders'
GO

----

CREATE TABLE [dbo].[Category] (
  [Category_Id] int IDENTITY(1, 1) NOT NULL,
  [Name] nvarchar(40) COLLATE Cyrillic_General_CI_AS NOT NULL,
  [Parrent_category] int NOT NULL,
  [Is_sub_category] bit NOT NULL,
  [Orders] smallint NULL,
  PRIMARY KEY CLUSTERED ([Category_Id])
)
ON [PRIMARY]
GO

EXEC sp_addextendedproperty 'MS_Description', N'сортировка', N'schema', N'dbo', N'table', N'Category', N'column', N'Orders'
GO

----


CREATE TABLE [dbo].[Date_Events] (
  [Date_Events_Id] int IDENTITY(1, 1) NOT NULL,
  [Date_event] date NOT NULL,
  [Expired] bit DEFAULT 0 NULL,
  PRIMARY KEY CLUSTERED ([Date_Events_Id])
)
ON [PRIMARY]
GO



---
CREATE TABLE [dbo].[Rel_Events_Date] (
  [Rel_Events_Date_Id] int IDENTITY(1, 1) NOT NULL,
  [Event] int NOT NULL,
  [Date_id] int NOT NULL,
  PRIMARY KEY CLUSTERED ([Rel_Events_Date_Id])
)
ON [PRIMARY]
GO



---
CREATE TABLE [dbo].[Views] (
  [Record_id] int NOT NULL,
  [Views] int DEFAULT 0 NOT NULL,
  [Type] smallint DEFAULT 0 NOT NULL,
  CONSTRAINT [Views_pk] PRIMARY KEY CLUSTERED ([Record_id])
)
ON [PRIMARY]
GO

EXEC sp_addextendedproperty 'MS_Description', N'0 - событие
1 - блог', N'schema', N'dbo', N'table', N'Views', N'column', N'Type'
GO

  //Событие детально 
        public EventsFull EventDetailed(int id)
        {
            EventsFull Ev = new EventsFull();
            using (IDbConnection db = new SqlConnection(connectionString))
            {
                try
                {
                    Ev = db.Query<EventsFull>("SELECT Event_Id, Title, Text, [User], Phone, Adress, Free, Category.Name,  Date_Event,  Time_From, Time_To, Views.Views         FROM Events, Category, Date_Events, Rel_Events_Date, Views  WHERE   Event_Id = " + id + " and Events.Category = Category.Category_Id and Events.Event_Id = Rel_Events_Date.Event and Date_Events.Date_Events_Id = Rel_Events_Date.Date_id and Views.Record_id = Events.Event_Id").SingleOrDefault(); 
                    
                }
                catch (Exception dbEx)
                {
                    string innEx = "";
                    if (dbEx.InnerException != null) { innEx = dbEx.InnerException.ToString(); }
                    Ev.Error = "EventDetailed id: " + id     + dbEx.Message + "  * " + innEx;
                    using (System.IO.StreamWriter sw = System.IO.File.AppendText(AppDomain.CurrentDomain.BaseDirectory + "LOGS/ERROR.LOG"))
                    {
                        sw.WriteLine(DateTime.Now.ToString() + " EventDetailed id: " + id + " " + Environment.NewLine + dbEx.Message.ToString() + Environment.NewLine + innEx);
                        sw.Flush();
                    }
                    throw dbEx;
                }
            }
            return Ev;
        }

 Event_Id = " + id + " and 

 public void Delete(int id)
        {
             using (IDbConnection db = new SqlConnection(connectionString))
             {
                 var sqlQuery = "DELETE FROM Users WHERE Id = @id";
                 db.Execute(sqlQuery, new { id });
             }
        }

 var sqlQueryDateEv = "INSERT INTO Date_Events (Date_Event) VALUES(@Date_Event); SELECT CAST(SCOPE_IDENTITY() as int )";
                    int idDate = db.Query<int>(sqlQueryDateEv, NewEvent).FirstOrDefault();   

SELECT Event_Id, Title, Text, [User], Phone, Adress, Free, cat.Name,  Date_Event,  Time_From, Time_To        
FROM Events 

INNER JOIN Category cat ON Events.Category = cat.Category_Id 
INNER JOIN Rel_Events_Date relDate ON Events.Event_Id = relDate.Event
INNER JOIN Date_Events de ON relDate.Date_id = de.Date_Events_Id

WHERE   Events.Event_Id = 3830 

CREATE TABLE [dbo].[Rel_Events_Date] (
  [Rel_Events_Date_Id] int IDENTITY(1, 1) NOT NULL,
  [Event] int NOT NULL,
  [Date_id] int NOT NULL,
  PRIMARY KEY CLUSTERED ([Rel_Events_Date_Id])
)
ON [PRIMARY]
GO

CREATE NONCLUSTERED INDEX [Rel_Events_Date_idx] ON [dbo].[Rel_Events_Date]
  ([Event])
WITH (
  PAD_INDEX = OFF,
  DROP_EXISTING = OFF,
  STATISTICS_NORECOMPUTE = OFF,
  SORT_IN_TEMPDB = OFF,
  ONLINE = OFF,
  ALLOW_ROW_LOCKS = ON,
  ALLOW_PAGE_LOCKS = ON)
ON [PRIMARY]
GO

CREATE TABLE [dbo].[Rel_Events_Date] (
  [Event] int NOT NULL,
  [Date_id] int NOT NULL,
  PRIMARY KEY CLUSTERED ([Event], [Date_id])
)