Selenium with C# 66 - Selenium data driven testing using MS SQL as data source in MS Test

Selenium data driven testing using MS SQL as data source in MS Test
#selenium #webdriver #automation #datadriventesting #qa
1:03 How to create a database table
2:12 Adding the data rows to the table
2:47 Code demo - Creation of test method
7:10 Test method execution
8:00 Possible interview questions on data driven testing using sql
Data driven testing using MS SQL and MS Test
How to create a database and table in MS SQL
Adding the data in to the table
Create a data driven test method which uses data from MS SQL table
Possible Interview Questions
1. How to use the MS SQL data as a source in selenium data driven testing?
2. What is a connection string?
3. What is the “Provider Invariant Name” for the MS SQL as data source?
Code :
[DataSource("System.Data.SqlClient",
"Server=.\\SQLExpress; Database=DataDrivenTesting;User Id=sa; Password=Ankpro01*",
"Student", DataAccessMethod.Sequential)]
[TestMethod]
public void DataDrivenTestingUsingSQL()
{
IWebDriver driver = new ChromeDriver();
driver.Manage().Window.Maximize();
driver.Url = "uitestpractice....";
driver.FindElement(By.Id("FirstName")).SendKeys(TestContext.DataRow[0].ToString().Trim());
driver.FindElement(By.Id("LastName")).SendKeys(TestContext.DataRow[1].ToString().Trim()); driver.FindElement(By.Id("EnrollmentDate")).SendKeys(TestContext.DataRow[2].ToString());
driver.FindElement(By.XPath("//input[@type='submit']")).Click();
Thread.Sleep(2000);
driver.Quit();
}

[@AnkproTraining]

Thank you for watching. Cheers! would you mind hitting *_like_* button and *_subscribe_* to our channel! That will be awesome. We would be grateful to you. And also share this video in your circle via whatsapp, facebook and twitter. Video timeline : 1:03 How to create a database table 2:12 Adding the data rows to the table 2:47 Code demo - Creation of test method 7:10 Test method execution 8:00 Possible interview questions on data driven testing using sql

[@rogerronan2222]

i realize I'm pretty randomly asking but does anyone know a good site to watch new series online ?

[@elondamon9885]

@Roger Ronan flixportal :D

[@rogerronan2222]

@Elon Damon Thank you, I went there and it seems like a nice service :) Appreciate it !!

[@elondamon9885]

@Roger Ronan you are welcome xD

[@KatRollo]

Is it possible to use DataSource to INSERT records instead?

[@aatishlute4681]

Not run this program I try my local SQL server

[@AnkproTraining]

Give the proper connection string. Thank you for watching this video. Don't forget to *_like , subscribe_* and hit that *_notification_* bell 🔔. And also share this video in your circle via *WhatsApp* , *Facebook* and *Twitter* . Link to subscribe the channel goo.gl/hFueBi

[@swagatmishra9350]

HOw to add wait time if the query is taking long time to execute. I am getting time out error in selenium as the query is taking longer time than expected.

[@BP-xy4uy]

Implicit wait

[@aatishlute4681]

U run this program local server or live server

[@xentechno2483]

Can any one help me I try this but not run

[@AnkproTraining]

You should give the proper connection string. Please let us know the error message you are receiving when the test case fails. Thank you for watching this video. Don't forget to *_like , subscribe_* and hit that *_notification_* bell 🔔. And also share this video in your circle via *WhatsApp* , *Facebook* and *Twitter* . Link to subscribe the channel goo.gl/hFueBi