MySQL In Asp.Net MVC CRUD Application Using Entity Framework

Поделиться
HTML-код
  • Опубликовано: 10 сен 2024
  • 🍒 Related Videos
    Asp.Net Core MVC CRUD Operations: • Asp.Net Core MVC CRUD ...
    MVC Login & User Registration: • Asp.Net Core MVC & Ide...
    Convert MVC App to Single Page(jQuery Ajax): • jQuery Ajax CRUD in AS...
    Expense Tracker App in Asp.Net Core MVC: • Build an Expense Track...
    More MVC Tutorials: • Asp.Net Core MVC Tutorial
    Required Software :
    MySQL Server 5.5: dev.mysql.com/...
    MySQL Connector For Net 6.9.9 : dev.mysql.com/...
    MySQL For Visual Studio 1.2.7 : dev.mysql.com/...
    MySQL WorkBench : dev.mysql.com/...
    📂 GitHub Repository
    ► goo.gl/UDZs2p
    💖 Channel Support
    ➤ Paypal: bit.ly/3L36ut4
    ➤ UPI App: geni.us/ScanQR...
    ➤ Amazon: geni.us/Amazon...
    💌 For Business Inquiries
    ➤ codaffection@gmail.com
    🚶‍♂️ Follow us
    Facebook : / codaffection
    Discord : / discord
    Twitter : / codaffection
    ---
    How to Create Asp.NET MVC With CRUD Operations Create Update Delete and View Using MySQL Server and Entity Framework.
    #AspNetMvc #MySQL #CodAffection

Комментарии • 70

  • @CodAffection
    @CodAffection  7 лет назад

    goo.gl/bPcyXW : Buy me a Coffee
    bit.ly/36IA1cH : AspNet Core MVC CRUD Operations
    bit.ly/3Pn2S7y : Expense Tracker App in AspNet Core MVC
    bit.ly/2yEPlpB : Convert MVC App to Single Page(jQuery Ajax)
    bit.ly/403lUVC : MVC Login & User Registration
    bit.ly/39B6xdh : Image Upload in AspNet Core MVC
    bit.ly/30fPDMg : More MVC Tutorials

  • @lipslide101
    @lipslide101 6 лет назад +54

    You know it's a real indian tutorial when he recorded this in the middle of the jungle

  • @AyushJain-ti5yu
    @AyushJain-ti5yu 4 года назад +4

    Hi , Im unable to get Model wizard page, after getting the version as 5x, that whole thing gets disappear after that page

  • @alisdamirov6961
    @alisdamirov6961 4 года назад +1

    Thank you so much man. Only this video among thousands solved my problem

    • @CodAffection
      @CodAffection  4 года назад +1

      Glad it helped

    • @gedelababi8
      @gedelababi8 Год назад

      im getting error at @6:49 after click 'ok' button
      error is ==> Method not found: 'System.String EnvDTE._DTE.get_Version()
      please help me brother ..i'm trying to since 3days still not yet done..pls help anyone

  • @jalphonso
    @jalphonso 6 лет назад +2

    Hello! @6:05 the Choose Model Contents in my case, didn't have the option "Generate from Database". It only contained "EF Designer from database", "Empty EF Designer model", "Empty Code First model", and "Code First from database". Which one should I choose?

    • @CodAffection
      @CodAffection  6 лет назад

      try Empty EF Designer model.

    • @gedelababi8
      @gedelababi8 Год назад

      im getting error at @6:49 after click 'ok' button
      error is ==> Method not found: 'System.String EnvDTE._DTE.get_Version()
      please help me brother ..i'm trying to since 3days still not yet done..pls help anyone

  • @faisalrana9945
    @faisalrana9945 3 года назад +1

    your doing great. Table is pronounces. tAble. .. a as in Ay.. the letters A T ay ble.
    thakns for the tutorial

    • @CodAffection
      @CodAffection  3 года назад

      thanks for the correction, really appreciated it.

  • @saikumar-ck2nq
    @saikumar-ck2nq 3 года назад

    I followed your instructions but when I run the project(Ctrl+F5), the url opens with MySql.Data.MySqlClient.MySqlException: Table 'SchemaName.SchemaName.table_name' doesn't exist.
    Dont know why schema name is coming twice in the error
    Can you please help understand why the error says table does not exist ? Is it because, schema name coming twice? How could I fix this ?
    I could see that database connected and table information can be viewed from Visual Studio. But while I run the project it is throwing error

  • @sarathv4913
    @sarathv4913 5 лет назад +1

    When I click on Next after adding the database the dialogue box just closes. It doesn't allow me to select the table for the Model class, nor does the class get added. Please help

    • @Zquirrelthing
      @Zquirrelthing 5 лет назад

      I have the exact same problem! Did you ever manage to solve it, because if so, please share the solution. It's driving me absolutely nuts

    • @emiliojehovanygonzalezmeji866
      @emiliojehovanygonzalezmeji866 4 года назад

      Me too, someone has the solution for this problem, thanks!

    • @emiliojehovanygonzalezmeji866
      @emiliojehovanygonzalezmeji866 4 года назад +1

      Well, i did it¡¡, for anyone who need it, this page was my solution:
      entityframework.net/knowledge-base/39110060/entity-framework-s-entity-data-wizard-crashes-when-connecting-to-mysql-database

    • @davixooo
      @davixooo 4 года назад

      Do not use Mysql.Data.Entity. You must use Mysql.data.EntityFramework. After this change, check if your versión of the nuget libraries are the same as the connector do you have installed.

  • @gedelababi8
    @gedelababi8 Год назад

    im getting error at @6:49 after click 'ok' button
    error is ==> Method not found: 'System.String EnvDTE._DTE.get_Version()
    please help me brother ..i'm trying to since 3days still not yet done..pls help anyone

  • @benildomabunda3980
    @benildomabunda3980 3 года назад

    Following the same steps but The window to setup the DB configuration closes before I can edit. Can anyone help, please?

  • @tiagoreis3221
    @tiagoreis3221 2 года назад

    My ears had a fucking stroke but my code is ok! Thank you

  • @tueresmejor4823
    @tueresmejor4823 3 года назад

    you have any proyect in vb2017

  • @gedelababi8
    @gedelababi8 Год назад

    im getting this error Method not found: 'System.String EnvDTE._DTE.get_Version()
    please help me anybody

  • @abbasawa372
    @abbasawa372 6 лет назад

    sir i'm using wind 7 pro x64 and my mysql for visual studio 1.2.7 msi is not installing in my window. it showing error" mysql for visual studio 1.2.7 wizerd ended prematuraly" :( I'm using vs 2017

  • @fatimatmercury6859
    @fatimatmercury6859 7 лет назад

    Thank you sooo much ! You have no idea how much this helped me !

    • @CodAffection
      @CodAffection  7 лет назад

      I am glad, you found the video helpful.

  • @gusfederal
    @gusfederal 5 лет назад +1

    niiiceee mann.. you is the bast developer

    • @CodAffection
      @CodAffection  5 лет назад +1

      Thank you for the wonderful feedback! :) I'm humbled.

  • @androidsavior
    @androidsavior 4 года назад

    C# is fucking awesome as hell as always

  • @Praxss
    @Praxss 3 года назад +1

    After 7:03 screen when press next it going back to 5:57 screen
    Plz help

    • @gedelababi8
      @gedelababi8 Год назад

      im getting error at @6:49 after click 'ok' button
      error is ==> Method not found: 'System.String EnvDTE._DTE.get_Version()
      please help me brother ..i'm trying to since 3days still not yet done..pls help anyone

  • @TamilPlaylist474
    @TamilPlaylist474 6 лет назад +1

    even though i install all the softwares i can't see mysql in connect while creating data help mee....

    • @nerivaldolourenco6034
      @nerivaldolourenco6034 4 года назад

      Este link vai ajudar: dev.mysql.com/doc/visual-studio/en/visual-studio-install.html

  • @AmeyaKherodkar
    @AmeyaKherodkar 6 лет назад +1

    I am unable to see MYSQL Database option in Change Data Source, I have used VS 2017 and with that, I am using Mysql for VS 1.2.6, MySql Server5.7.17 and Connector/Net 6.6.7,6.10.4 but none of them worked. What would be the possible reason?

    • @CarlVictorFontanos
      @CarlVictorFontanos 6 лет назад

      Same here

    • @alonsojulianpumachaguarosa367
      @alonsojulianpumachaguarosa367 6 лет назад

      same here, did you find a solution guys?

    • @yagoparola
      @yagoparola 6 лет назад

      same here

    • @mstephencrowell
      @mstephencrowell 6 лет назад

      Uninstalling/reinstalling Connector and MySQL for VS, then and copying assembly files from C:\Program Files (x86)\MySQL\MySQL Connector Net 6.9.8\Assemblies\v4.5 to C:\Program Files (x86)\Microsoft Visual Studio 12.0\Common7\IDE worked for me. Source: stackoverflow.com/questions/4235291/how-to-connect-to-a-mysql-data-source-in-visual-studio

    • @cesarcabrera4855
      @cesarcabrera4855 6 лет назад

      look this in
      www.c-sharpcorner.com/article/code-first-migration-asp-net-mvc-5-with-entityframework-mysql/

  • @techwithdenis
    @techwithdenis 5 лет назад

    I have a problem, after choosing my database connection, the
    options: NO, exclude sensitive data from the connection string. I will set it in my application code ... AND the
    option: Yes, include the sensitive data in the connection string... are both grayed out/disabled so i can not pass this stage...
    Am using Xamp with MySQL Work Bench

    • @linhamilionaria
      @linhamilionaria 4 года назад

      tens que adicionar uma senha no seu server

    • @gedelababi8
      @gedelababi8 Год назад

      im getting error at @6:49 after click 'ok' button
      error is ==> Method not found: 'System.String EnvDTE._DTE.get_Version()
      please help me brother ..i'm trying to since 3days still not yet done..pls help anyone

  • @Rammurthy_Raj
    @Rammurthy_Raj 6 лет назад

    i installed given four tools but in connection its not visible

  • @tamilkumarang
    @tamilkumarang 6 лет назад

    Nice video. Good explanation

  • @minhtaipham6074
    @minhtaipham6074 6 лет назад

    thank you so much

  • @Mr_Uk926
    @Mr_Uk926 6 лет назад

    Very Thank you!

  • @magapon869
    @magapon869 6 лет назад

    Элементарно не видит MySQL, даже когда установил все необходимые файлы. Как можно решить проблему? Переустановка не помогла

    • @magapon869
      @magapon869 6 лет назад

      Нашёл решение. На проекте через nuGet нужно скачать и подключить mysql.data.entity

    • @nerivaldolourenco6034
      @nerivaldolourenco6034 4 года назад

      Veja a versão do Mysql connetion e do Mysql for visual Studio tens que Intalar no Link a baixo : dev.mysql.com/doc/visual-studio/en/visual-studio-install.html

  • @chusnulchotimah4912
    @chusnulchotimah4912 6 лет назад

    thank you

  • @achuachyuth6908
    @achuachyuth6908 7 лет назад

    Can you do it for Oracle Db instead of MySQL ?

    • @CodAffection
      @CodAffection  7 лет назад

      I will try, thanks for your suggestion.

  • @maredumalleshwari8327
    @maredumalleshwari8327 Год назад

    hi sir, how can i find out mysql workbench root password

    • @gedelababi8
      @gedelababi8 Год назад

      it will ask when install the mysql

  • @SB-wc6fd
    @SB-wc6fd Год назад

    Clear noise then re-upload

  • @taniax8944
    @taniax8944 6 лет назад +1

    not work at 7:20

    • @CodAffection
      @CodAffection  6 лет назад

      what happened ?

    • @taniax8944
      @taniax8944 6 лет назад

      Dotnet Mob new version of connector etc is not compatible with EF 6 but I downloaded your version and do exactly the same as you shown and it worked . I forgot to delete my comment sorry .

    • @gedelababi8
      @gedelababi8 Год назад

      im getting error at @6:49 after click 'ok' button
      error is ==> Method not found: 'System.String EnvDTE._DTE.get_Version()
      please help me brother ..i'm trying to since 3days still not yet done..pls help anyone

  • @nayanamtanuj
    @nayanamtanuj 7 лет назад

    Please do code first migration