Re: What is the best way to create your Database (tables..etc) using C# ? - C# Discussion Boards

Re: How to get the HttpResponseHeader in c#,c++ ?

Maciej Los12-Sep-19 3:30

Maciej Los

12-Sep-19 3:30

No.

You have to post the piece of code which drives you crazy here, on CP forum.

Re: How to get the HttpResponseHeader in c#,c++ ?

ZurdoDev11-Sep-19 1:09

ZurdoDev

11-Sep-19 1:09

How can we help?

Social Media - A platform that makes it easier for the crazies to find each other.

Everyone is born right handed. Only the strongest overcome it.
Fight for left-handed rights and hand equality.

Re: How to get the HttpResponseHeader in c#,c++ ?

Member 1457084312-Sep-19 3:03

Member 14570843

12-Sep-19 3:03

I ask for help, what do you mean?

Re: How to get the HttpResponseHeader in c#,c++ ?

ZurdoDev12-Sep-19 3:36

ZurdoDev

12-Sep-19 3:36

You have asked us to do all the work for you. You have not shown any code that you have done nor have you explained clearly where you are stuck.

Social Media - A platform that makes it easier for the crazies to find each other.

Everyone is born right handed. Only the strongest overcome it.
Fight for left-handed rights and hand equality.

Re: How to get the HttpResponseHeader in c#,c++ ?

Luc Pattyn11-Sep-19 3:42

Luc Pattyn

11-Sep-19 3:42

Hi,

look for the HttpRequest and HttpResponse classes, and in particular the HttpResponse.Header property. Once you got the headers, you can extract specific info like so:

IEnumerable<string> values;
if (headers.TryGetValues("X-BB-SESSION", out values))
{
  string session = values.First();
}

Luc Pattyn [My Articles] Nil Volentibus Arduum

What is the best way to create your Database (tables..etc) using C# ?

Abdalla Ben Omran10-Sep-19 4:18

Abdalla Ben Omran

10-Sep-19 4:18

let me assume that i want to create 2 Tables with FK...etc using C#
what have I from choices.. ADO.Net, Dapper, EF or something else !

- What is the benefit,advantages and disadvantages to use Code First ?

- Should I use normal SQL Server managment Studio to design and create my tables and relationships ?

Re: What is the best way to create your Database (tables..etc) using C# ?

CHill6010-Sep-19 4:31

CHill60

10-Sep-19 4:31

I'll throw my opinion into this … but bear in mind that this is only an opinion, I'm sure others will shout me down and that's ok too.

- I cannot think of a single advantage of Code First.

- I personally only ever use SSMS to create my tables, relationships etc.

There are arguments to both sides e.g. entity framework - Code-first vs Model/Database-first[^]

Re: What is the best way to create your Database (tables..etc) using C# ?

Abdalla Ben Omran10-Sep-19 4:47

Abdalla Ben Omran

10-Sep-19 4:47

I agree you . i don't like to use EF for many reasons and yes you have right
EF wrote for you everything and that is the part which is almost don't like it
When things go wrong, you are going to need to look deep into the code from EF wrote for you. So how fast can you read and undersatand the generated code so that you can identify what the issue is and how to fix it? and etc etc .. but sometimes it's interesting to create tabels or use Code first using C# Dapper Plus for instance doing great job about it .

Re: What is the best way to create your Database (tables..etc) using C# ?

Maciej Los10-Sep-19 20:44

Maciej Los

10-Sep-19 20:44

Completely agree!

Re: What is the best way to create your Database (tables..etc) using C# ?

OriginalGriff10-Sep-19 4:51

OriginalGriff

10-Sep-19 4:51

I agree with CHill60 - I always use SSMS.
Data design is too important, it needs careful thinking about if it's going to be both performant and flexible. Far, far too easy to "let the machine do it" and it makes unwanted assumptions about your data that lead to problems later.

Sent from my Amstrad PC 1640
Never throw anything away, Griff
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
AntiTwitter: @DalekDave is now a follower!

Re: What is the best way to create your Database (tables..etc) using C# ?

Abdalla Ben Omran10-Sep-19 5:03

Abdalla Ben Omran

10-Sep-19 5:03

OriginalGriff wrote:
I agree with CHill60 - I always use SSMS.

nice to hear your opinion

Re: What is the best way to create your Database (tables..etc) using C# ?

Richard Deeming10-Sep-19 4:53

Richard Deeming

10-Sep-19 4:53

Abdalla Ben Omran wrote:
Dapper

As far as I can see, Dapper[^] simply maps the query results to objects. It doesn't provide any utilities for creating or maintaining database structure, other than raw ADO.NET commands.

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

Re: What is the best way to create your Database (tables..etc) using C# ?

Abdalla Ben Omran10-Sep-19 4:59

Abdalla Ben Omran

10-Sep-19 4:59

yes you are right . i thought its doing Code First as well.

Re: What is the best way to create your Database (tables..etc) using C# ?

Abdalla Ben Omran10-Sep-19 5:19

Abdalla Ben Omran

10-Sep-19 5:19

Richard Deeming wrote:
As far as I can see, Dapper[^] simply maps the query results to objects. It doesn't provide any utilities for creating or maintaining database structure, other than raw ADO.NET commands.

look here please. that what i have meant

Online Example | Dapper Plus[^]

Re: What is the best way to create your Database (tables..etc) using C# ?

Gerry Schmitz10-Sep-19 6:02

Gerry Schmitz

10-Sep-19 6:02

Depends on whether it is new development or "maintenance".

With new development, the requirements and feasibility (e.g. skills; interfacing) dictate the technology.

With maintenance, you stick with what's there.

(it's never as simple as picking items from a menu).

The Master said, 'Am I indeed possessed of knowledge? I am not knowing. But if a mean person, who appears quite empty-like, ask anything of me, I set it forth from one end to the other, and exhaust it.'
― Confucian Analects

Re: What is the best way to create your Database (tables..etc) using C# ?

MadMyche10-Sep-19 8:36

MadMyche

10-Sep-19 8:36

I generally parallel the tables and classes; generally I will write out the class properties and copy/paste via Excel into a new SSMS query window.

If it is an existing table, I will open in design view; then copy/paste into as the properties of a new class object (again via Excel).

Director of Transmogrification Services
Shinobi of Query Language
Master of Yoda Conditional

Re: What is the best way to create your Database (tables..etc) using C# ?

Maciej Los10-Sep-19 20:46

Maciej Los

10-Sep-19 20:46

It's interesting.

Are you using VBA code?

Re: What is the best way to create your Database (tables..etc) using C# ?

Abdalla Ben Omran10-Sep-19 21:57

Abdalla Ben Omran

10-Sep-19 21:57

Maciej Los wrote:
It's interesting.

Are you using VBA code?

No. i am using C#
Sqlcommand to create tables and using Dapper to read,insert ...etc
what do you use or what do you prefer to use ?

Re: What is the best way to create your Database (tables..etc) using C# ?

Maciej Los10-Sep-19 22:00

Maciej Los

10-Sep-19 22:00

Well...
I know that you're using C#. I was asking @MadMyche about using Excel in a process of creating/updating database tables.

Re: What is the best way to create your Database (tables..etc) using C# ?

Abdalla Ben Omran10-Sep-19 22:16

Abdalla Ben Omran

10-Sep-19 22:16

oh ja .. sorry i thought you have asked me .
by the way .. do you use IQueryable with Linq ?

Re: What is the best way to create your Database (tables..etc) using C# ?

MadMyche11-Sep-19 1:43

MadMyche

11-Sep-19 1:43

No to the VBA, no Entity Framework, no LINQtoSQL; I am an ADO purist.

But I'll try to explain the process if it helps. After typing this it does seems really wordy and long but after many years of doing it this way it is only a matter of minutes.

Create class properties in C#
Copy the properties and paste in Notepad
Use find/replace to replace spaces with tabs
Copy the contents and paste into Excel
Add column for natural index (1,2,3)
Sort by Net Data Type
Add column for SQL Data Type alongside NET data type, and populate
Rerrange columns around to match format of CREATE TABLE syntax
Copy and paste the desired columns into SSMS new query window

The process for SQL design to a class is similar.

I also reuse/tweak the Excel content to create instances (overloaded constructs) from IDataReaders or DataRows.

Director of Transmogrification Services
Shinobi of Query Language
Master of Yoda Conditional

Re: What is the best way to create your Database (tables..etc) using C# ?

Maciej Los11-Sep-19 1:59

Maciej Los

11-Sep-19 1:59

Nice!

Well... I'm lazy, so - probably - i'd prefer to automate it via c# code. I'd create a programme wich will acts as you described in 2-3 and 5-8. I'd save final result in a text file (with .sql extension) and use it in SSMS window.

I like your idea and i really appreciate it.

Re: What is the best way to create your Database (tables..etc) using C# ?

MadMyche11-Sep-19 3:50

MadMyche

11-Sep-19 3:50

Glad it can be used, even if it is only inspirational... I guess I'm too lazy to write the program to do it

Director of Transmogrification Services
Shinobi of Query Language
Master of Yoda Conditional

laziness is a reason for progress

Maciej Los11-Sep-19 4:03

Maciej Los

11-Sep-19 4:03

Re: laziness is a reason for progress

MadMyche11-Sep-19 4:10

MadMyche

11-Sep-19 4:10

I'll put it onto my ToDo list

Director of Transmogrification Services
Shinobi of Query Language
Master of Yoda Conditional

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.