Tried some 4 other EF tutorials today, had to deal with a ton of superfluous information while this one is straight to the point and just works. Thank you!
I like how you selectively skipped ICollection populating part For those who don't know why does your ICollection empty, `.Include("CollectionFieldName")` syntax must be used when fetching an object
A very good series of tutorial videos, but the last video contains useful tips about tools and materials that are relevant for all videos before (1-5), Everybody should watch video 6 first.
Nice work Chief. However, it would have been better to mention the primary functions of the ...Design and ..Tools nugets and what cannot be done without it.
I'm typing out every cs file since they are not in github files as far as I can see. Any ideas? By the way, I wrote this same comment yesterday and it's not here now. I suppose it got deleted?
Very nice, but without experience in database programming the user has no chance of understanding what is happening. So it's not for beginners at all, but for EF Core beginners ;-) How I can connect to a MySQL database?
I really wish we could use EF Core but as far as I know, it does not support the database my company is stuck using - IBM for i or DB2 iSeries (or whatever it’s called these days). To make it worse we are stuck on version v5r4! 😢 Does anybody know if EF Core can be used for this as I haven’t been able to find anything for years.
when I try the command Update-Database i get the error A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) how can i fix it
Is this still relevant for someone starting with .NET 8 and VS2022.... I think I'll use Dapper for some SQL interface as I like to see what's happening under the hood (I have good SQL skills) but the whole migrations/class building and/or database updates seem ideal for EF plus perhaps the basic CRUD operations.
What an excellent video! Including the .NET CLI instructions on top of the usual VSCode package manager was very helpful indeed, as I prefer vim/nvim over VSCode. Thanx a lot =D
when I try to update database I get this error A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted.)
Entities represent tables in the database and are used to map the database schema using a class. Each instance of an entity corresponds to a row in the database table. On the other hand, a model is any class that represents data within the application. Models are used for various purposes, such as displaying data, transferring data, or encapsulating domain logic.
The tutorial is great. But guys be advised you need different packages if you use MySQL and not SQL like in this tutorual. Coz I'm a noob at this and spent the whole day trying to figure out why i can't connect to the DB.
hello, thanks for the video. I've a question. How can I create those tables in another DB in my local server, letsay the name of the Database is DiscApp. Thanks
Good Video, but I have one question, when I try the command Add-Migration, I get the failure, that Android will not be supported. So I tried to make a DummyProject, like the documentation says, but it doesn't work... Can someone help me?
Sqlcmd: Error: Microsoft ODBC Driver 17 for SQL Server : Login failed for user 'SA'.. Does anybody know why that happens every time I'm trying to connect to sqlserver? I'm on macOS and using a container for the database and I've used both connection strings Cam has provided. Nothing has worked so far.Thanks
Error CS0053 Inconsistent accessibility: property type 'Customer' is less accessible than property 'Order.Customer' 5:00 The solution is to remove public modifier of declaration.
they are both different things, .net 8 its a version of a whole c# library, EF Core its a framework used to manage data more easily, its like SQL but converted in C# language. if im wrong someone correct me pls, but i think thats basically it.
Yes it would delete whatever you removed from the model. It is essentially creating a new instance of whatever exists in said model, not just adding what is new to the model.
for those who are having an error on connecting the server, because it says its not trusted, you have to write this in the connection string: --------------TrustServerCertificate=true;--------------------
Getting this error on update-database command on my local sql server A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted.) Please help
In this context, I keep getting an error with the update database. A network-related error or an instance error was detected. I have now managed to get the database visible in SQL Server Explorer, but when I run Update-Database I also get a long error message with this note: A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - The certificate chain was issued by an untrusted certificate authority). Can anyone tell me how to solve this? Maybe renew the certificate, etc.?
May I know what is the difference between the followings in the model: [Required] public string? Name {get; set;} public string? Name{get;set;} public string {get; set;} = null!
i hope you already know the answer, but ill just leave it here in any case: public string? Name{get;set;} -> null can be assigned to this property and nothing happends public string {get; set;} = null! -> null CANT be assigned to this property but with this " = null!" you say to the complier that you are aware about it and possible risks such as null ref exception ecc. [Required] public string? Name {get; set;} -> does not make a lot of sense actually... [Required] attribute is used to indicate that a property must have a value and cannot be null. However, when you use the string? syntax, it already indicates that the property can be null. so its better to use [Required] with the first example if you want to enforce the non-null requirement for a string property,
I have been following the tutorial. I need some help regarding a query on how to get data from two tabels where second table has foreign key from first table? I tried few Linq but ended up getting error of datareader being open
Go to the GitHub repository in the description. The project in Part 5 does what you're asking in parts/5-performance-tips/ContosoPizza/Pages/Customers/Details.cshtml.cs line 32
Hi Cam Soper. This isn't really a "for Beginners" playlist. There are so many things not described here. What are migrations and why did you create them? I have to pause/leave this video and go somewhere else. And that place throws me off into a different tangent. Why doesn't Microsoft respect developer's time? It's not funny, it's insulting.
I am sorry, but this just made my blood boil... i cannot agree with this type of approach. if the intention is to create a "for beginners" series, core concepts should be introduced first instead of just typing s***t away (in this case paste). Julie Lerman needed a couple of books to explain this framework properly: Code first, database first, annotattions, linq to entities, linq to objects, change tracking, concurrency handling, etc etc. the dbcontext class alone gets an entire book dedicated to it... no one really learns anything with this type of video, but they may be fooled to think that they did.
On the contrary... It was exactly what I needed. It got me up and running really quickly and I didn't have to read a s***t load of books which would cause me to fall asleep and never really get started. I have work to do and just want something that works. (I've been a software engineer for over 40 years and really wanted to get to know the latest EF... which I am a "beginner" at. Finally, something that is good, to-the-point, and, frankly, I can understand the English without dealing with an accent. There are so many (well meaning) people out there that are making videos which are not understandable to me, due to the very heavy accents. I know the content is good, but I never can follow it comfortably. I really, really needed this.
This database will perform like 💩in a high volume production environment. If you look at the migration generated, all string columns translate to a NVARCHAR(MAX) data type. NVARCHAR(MAX) will absolutely kill your database server performance. This is one of the many gotchas in EF. You must annotate all string properties in your classes to set maximum lengths if you plan to do a code first approach. EF is a great tool but it's really easy to shoot yourself in the foot in production environments. Use with caution.
Why do you say that. The VAR in NVARCHAR means it contains the length. Do you have any evidence to support your claim? What you assert is a common myth.
I'm sorry, I tried to make sure it was a good balance of large enough to read and small enough to make good use of pixels. I recorded it at 1080p and I had the Windows 11 DPI settings set to 120%. I'll try to do better next time!
Lots of technical mistakes. You are going to confuse a lot of people. You should have someone more technical review the video before you post it. If they are just you mis-speaking, you should review your own video before you post it. Corrections should go in the video as annotations, not in the notes. People don't read the notes.
Create tables automatically ? This is absolutely ridiculous. In the corporate world the DB is always created separately and very carefully. this technology may be suitable to use in very small systems. NEVER will be accepted In the corporate world. ORM is like: technology for children. :)
@@DannysGalaxyTab I wouldn't hire anyone who didn't know SQL, even if the system was using an ORM. SQL is still indispensable if you want any chance of having a high-performant system.
![Working with an Existing Database [2 of 5] | Entity Framework Core for Beginners](http://i.ytimg.com/vi/DCYVfLT5_QI/mqdefault.jpg)
![Working with an Existing Database [2 of 5] | Entity Framework Core for Beginners](/img/tr.png)
Tried some 4 other EF tutorials today, had to deal with a ton of superfluous information while this one is straight to the point and just works. Thank you!
This is brilliant. Simple. Straight to the point.
I like how you selectively skipped ICollection populating part
For those who don't know why does your ICollection empty, `.Include("CollectionFieldName")` syntax must be used when fetching an object
Great video, a clear practical example. Thanks Sam!
Alternative title: Darth Sidious getting you started with the dark side
Ha. So true, but it still isn't clear to me how devs get seduced by the dark side. Seems like groupthink or "religious" indoctrination.
A very good series of tutorial videos, but the last video contains useful tips about tools and materials that are relevant for all videos before (1-5), Everybody should watch video 6 first.
Excellent video. I have reproduced all by myself and it worked wonderfully. Thanks a lot.😀
Thanks very much. Even though I've been using EF for a long time, there were still some things that I learned here and/or which got cleared up better.
Amazing content! please keep on producing high quality knowledge.
Simply: Great!
One of the best tutorial I've ever seen!...Clear and to the point!
Can't wait to see the rest episodes. 😃😃
Excellent. Question: Would it work with postman?
Nice work Chief. However, it would have been better to mention the primary functions of the ...Design and ..Tools nugets and what cannot be done without it.
I'm typing out every cs file since they are not in github files as far as I can see. Any ideas? By the way, I wrote this same comment yesterday and it's not here now. I suppose it got deleted?
you save my job, thnks
when i do the Add-Migration InitialCreate and Update-Database i dont see the database on the Sql Server object Explorer any help ??
Very nice, but without experience in database programming the user has no chance of understanding what is happening. So it's not for beginners at all, but for EF Core beginners ;-)
How I can connect to a MySQL database?
I really wish we could use EF Core but as far as I know, it does not support the database my company is stuck using - IBM for i or DB2 iSeries (or whatever it’s called these days).
To make it worse we are stuck on version v5r4! 😢
Does anybody know if EF Core can be used for this as I haven’t been able to find anything for years.
when I try the command Update-Database i get the error
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
how can i fix it
Do I have to setup SQL-Server and making tables
before to do this ?
Is this still relevant for someone starting with .NET 8 and VS2022.... I think I'll use Dapper for some SQL interface as I like to see what's happening under the hood (I have good SQL skills) but the whole migrations/class building and/or database updates seem ideal for EF plus perhaps the basic CRUD operations.
What an excellent video! Including the .NET CLI instructions on top of the usual VSCode package manager was very helpful indeed, as I prefer vim/nvim over VSCode. Thanx a lot =D
0:50 "Each order detail contains a product and quantity"
The connecting line on the diagram is many-to-many. Is it wrong?
I think its wrong
when I try to update database I get this error
A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted.)
You might try adding "TrustServerCertificate=true;" to the connection string.
Simple and complet dekclaration! Very helpful! Thank you very much 🙏
Excellent video. Thanks bro!
I rly appreciate for doing videos like this. You're helping me a lot.
Take Care!
Thank you very much ! Great teaching !
03:48 Why is it called an entity when its under a folder called "Models"? Is it a model or is it an entity? I am so confused.
Entities represent tables in the database and are used to map the database schema using a class. Each instance of an entity corresponds to a row in the database table.
On the other hand, a model is any class that represents data within the application. Models are used for various purposes, such as displaying data, transferring data, or encapsulating domain logic.
Awesome explanation
The tutorial is great. But guys be advised you need different packages if you use MySQL and not SQL like in this tutorual. Coz I'm a noob at this and spent the whole day trying to figure out why i can't connect to the DB.
Its simple and clear, Can I find more advanced tutorials on this please.
Absolutely brilliant video tutorials! Subscribed!
Why doesn’t the class Product have an ICollection OrderDetails {get; set;} the way the class Order has it?
If you need to retrieve all order details for this order, you can do that. It is, however, not needed for this tutorial
hello, thanks for the video. I've a question. How can I create those tables in another DB in my local server, letsay the name of the Database is DiscApp. Thanks
Good Video, but I have one question, when I try the command Add-Migration, I get the failure, that Android will not be supported. So I tried to make a DummyProject, like the documentation says, but it doesn't work... Can someone help me?
Why is it when we remove we don’t interact with the DBSet ?
Sqlcmd: Error: Microsoft ODBC Driver 17 for SQL Server : Login failed for user 'SA'.. Does anybody know why that happens every time I'm trying to connect to sqlserver? I'm on macOS and using a container for the database and I've used both connection strings Cam has provided. Nothing has worked so far.Thanks
Error CS0053 Inconsistent accessibility: property type 'Customer' is less accessible than property 'Order.Customer' 5:00
The solution is to remove public modifier of declaration.
No! All you need is to make sure the Packages are 6.0.4! I had many problems using 6.0.8
@@ahmedfattal9569 and how did you fixed that?
@@ДенисГовдиш Install 6.0.4 instead of newer ones
No if you change the product class from internal to public it should work
or move it into the same assembly and declare everything there as internal.
How is EF Core [8] different from .Net [8] ??? I'm really confused. I couldn't find any comparison on the internet or even on MS website.
they are both different things, .net 8 its a version of a whole c# library, EF Core its a framework used to manage data more easily, its like SQL but converted in C# language.
if im wrong someone correct me pls, but i think thats basically it.
IS it possible to use EF Core InMemory for CosmosDB ?
Does add migration removes the previous tables and data? What if table already has data and I have to add a new column. Would it delete the data?
Yes it would delete whatever you removed from the model. It is essentially creating a new instance of whatever exists in said model, not just adding what is new to the model.
Isn't the relationship b/w OrderDetail and Product must be 1-M ? OrderDetail is actually a Gerund (aka Associative Entity)!
Thank you for posting these.
That tool bar in the bottom, how can I set it up in my VS?
Excellent video
Any plans to explain relationships like hasmanythrough or pivots?
Nice job. Well done.
for those who are having an error on connecting the server, because it says its not trusted, you have to write this in the connection string:
--------------TrustServerCertificate=true;--------------------
Getting this error on update-database command on my local sql server
A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted.)
Please help
Put "TrustServerCertificate=true;" in the connection string
What do you mean by use a secure storage method for real world connection? Which other method do you mean? Thanks.
You would want to read this value from something like azure key vault. Either that, or a configuration file at the very least.
thanks, helped me a lot!
In this context, I keep getting an error with the update database.
A network-related error or an instance error was detected.
I have now managed to get the database visible in SQL Server Explorer, but when I run Update-Database I also get a long error message with this note: A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - The certificate chain was issued by an untrusted certificate authority).
Can anyone tell me how to solve this? Maybe renew the certificate, etc.?
"ConnectionStrings": {
"YourConnectionString": "Data Source= blablabla ;TrustServerCertificate=True;"
}
May I know what is the difference between the followings in the model:
[Required]
public string? Name {get; set;}
public string? Name{get;set;}
public string {get; set;} = null!
i hope you already know the answer, but ill just leave it here in any case:
public string? Name{get;set;} -> null can be assigned to this property and nothing happends
public string {get; set;} = null! -> null CANT be assigned to this property but with this " = null!" you say to the complier that you are aware about it and possible risks such as null ref exception ecc.
[Required]
public string? Name {get; set;} -> does not make a lot of sense actually... [Required] attribute is used to indicate that a property must have a value and cannot be null. However, when you use the string? syntax, it already indicates that the property can be null. so its better to use [Required] with the first example if you want to enforce the non-null requirement for a string property,
Wow Good video, Thanks a lot ^^
Well done!
So we have to manually do all the work that the older EF implementations did for us via the diagrams.
Got it.
I have been following the tutorial. I need some help regarding a query on how to get data from two tabels where second table has foreign key from first table?
I tried few Linq but ended up getting error of datareader being open
Go to the GitHub repository in the description. The project in Part 5 does what you're asking in parts/5-performance-tips/ContosoPizza/Pages/Customers/Details.cshtml.cs line 32
What is the our approach in this video? Code first or Model first.
it's code first method
is it possible to use this for macOS?
Yes, I am developing on macOS, Visual Studio 2022 with Entity Framework Core. I hope this helps.
@@MulkRaj101 Cam you connect to SQL Server cause I've tried everything but I can't
@@younesmdarhrialaoui643 I am using SQLite.
Let's go !!!
This is lovely
why is he not using brackets in the using block?
The syntax I use in the video disposes of the object when it falls out of scope. Same thing as with the brackets, just simpler.
Where ?
@@do-electronics 11:15 when declaring the context
Perfect
Thank you
Thank you very much.
You're welcome! 😊
great tutor ❤
has anybody tried this on macOS?
Are you sure your name is not meant to be Sam Cooper
Hi Cam Soper. This isn't really a "for Beginners" playlist. There are so many things not described here. What are migrations and why did you create them? I have to pause/leave this video and go somewhere else. And that place throws me off into a different tangent. Why doesn't Microsoft respect developer's time? It's not funny, it's insulting.
Great video. Just that I wish i could see how the solution was set up. It shows its a Console app not much how to set up
This is not for beginners ...
did not show how to do a connection string terrible
I am sorry, but this just made my blood boil... i cannot agree with this type of approach. if the intention is to create a "for beginners" series, core concepts should be introduced first instead of just typing s***t away (in this case paste). Julie Lerman needed a couple of books to explain this framework properly: Code first, database first, annotattions, linq to entities, linq to objects, change tracking, concurrency handling, etc etc. the dbcontext class alone gets an entire book dedicated to it... no one really learns anything with this type of video, but they may be fooled to think that they did.
On the contrary... It was exactly what I needed. It got me up and running really quickly and I didn't have to read a s***t load of books which would cause me to fall asleep and never really get started. I have work to do and just want something that works. (I've been a software engineer for over 40 years and really wanted to get to know the latest EF... which I am a "beginner" at. Finally, something that is good, to-the-point, and, frankly, I can understand the English without dealing with an accent. There are so many (well meaning) people out there that are making videos which are not understandable to me, due to the very heavy accents. I know the content is good, but I never can follow it comfortably. I really, really needed this.
Cool
This database will perform like 💩in a high volume production environment. If you look at the migration generated, all string columns translate to a NVARCHAR(MAX) data type. NVARCHAR(MAX) will absolutely kill your database server performance. This is one of the many gotchas in EF. You must annotate all string properties in your classes to set maximum lengths if you plan to do a code first approach. EF is a great tool but it's really easy to shoot yourself in the foot in production environments. Use with caution.
u can change the NVARCHAR(MAX) to any number u want , data annotations are old and useless, EF Core is powerful in the right hands.
u know that this is a entry-level tutorial which does not address performance, right, dip💩 ?
@@fadidib8516 Why data annotations are old?
Why do you say that. The VAR in NVARCHAR means it contains the length. Do you have any evidence to support your claim? What you assert is a common myth.
@@Rubicon43 isn t a DB either a Var or a Nvar just different length and type of ANSII or UTF8
Too small to see.
I'm sorry, I tried to make sure it was a good balance of large enough to read and small enough to make good use of pixels. I recorded it at 1080p and I had the Windows 11 DPI settings set to 120%. I'll try to do better next time!
Just zoom in. It's 100% way better than any EF videos on the web.
@@camsoper7902 You did it right. It's perfectly visible. on4ayl just needs to hit the fullscreen button.
This guys goes too fast and misses some details that beginners will miss
Lots of technical mistakes. You are going to confuse a lot of people. You should have someone more technical review the video before you post it. If they are just you mis-speaking, you should review your own video before you post it. Corrections should go in the video as annotations, not in the notes. People don't read the notes.
Create tables automatically ? This is absolutely ridiculous. In the corporate world the DB is always created separately and very carefully.
this technology may be suitable to use in very small systems. NEVER will be accepted In the corporate world.
ORM is like: technology for children. :)
Someone's regretting sinking years of their life into learning SQL...
Yeah, ORM has been a cancer in every large system where I've seen it implemented.
@@DannysGalaxyTab I wouldn't hire anyone who didn't know SQL, even if the system was using an ORM. SQL is still indispensable if you want any chance of having a high-performant system.
help
@dotnet