public static void CreateClient(string name, string phoneNumber, bool orderDone, List <Cars> cars) { Client data = new Client { Name = name, PhoneNumber = phoneNumber, OrderDone = orderDone, Cars = cars }; string sql = @"insert into dbo.Client (Name, PhoneNumber, OrderDone) values (@Name, @PhoneNumber, @OrderDone);"; SqlDataAccess.SaveData(sql, data); var carName = ConvertToEnglish(name) + "Cars"; string sqlcreate = @"create table [dbo].[" + carName + @"] ([Id] INT NOT NULL PRIMARY KEY IDENTITY, [CarName] NVARCHAR(50) NOT NULL, [Model] NVARCHAR(50) NOT NULL, [VIN] NVARCHAR(50) NOT NULL, [EngineVolume] FLOAT NOT NULL, [ManufactureYear] DATETIME NOT NULL, [Defects] NVARCHAR(50) NOT NULL, [ClientId] NVARCHAR(50) NOT NULL);"; using (IDbConnection cnn = new SqlConnection(SqlDataAccess.GetConnectionString())) { cnn.Execute(sqlcreate); } foreach (var c in cars) { Car car = new Car { CarName = ConvertFromEnum(c.Name), Model = c.Model, VIN = c.VIN, EngineVolume = (float)c.EngineVolume, ManufactureYear = c.ManufactureYear, Defects = GetFromList(c.DefectsDescription), ClientId = data.Name }; string sqldata = @"insert into dbo." + carName + @" (CarName, Model, VIN, EngineVolume, ManufactureYear, Defects, ClientId) values (@CarName, @Model, @VIN, @EngineVolume, @ManufactureYear, @Defects, @ClientId);"; SqlDataAccess.SaveData(sqldata, car); } }